SELECT permission denied on object 'sysproperties', database 'mrs', owner 'dbo'.
Brian Donahue
Posts: 6,590 Bronze 1
Hi Paul,
It sounds like you've had your rights revoked on some system tables.
These tables contain SQL Server object information, Extended Properties, and
dependency information. SQL Compare needs to get to that information to work
properly, in addition to the User tables that you actually want to
synchronize.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Riker" <paulriker@hotmail.com> wrote in message
news:UPcDoBVJEHA.1612@server53...
> I keep getting this error message when trying to compare. Any ideas?
>
>
It sounds like you've had your rights revoked on some system tables.
These tables contain SQL Server object information, Extended Properties, and
dependency information. SQL Compare needs to get to that information to work
properly, in addition to the User tables that you actually want to
synchronize.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Riker" <paulriker@hotmail.com> wrote in message
news:UPcDoBVJEHA.1612@server53...
> I keep getting this error message when trying to compare. Any ideas?
>
>
This discussion has been closed.
