Is it possible to include system objects in a comparison?
dougr
Posts: 2
Hi -
I have a number of common stored procedures that I have added to the master database and then marked with EXEC sys.sp_MS_marksystemobject sp_MySproc so that they are available to all databases on the server.
Is there a way to do this? I checked under the project options along with trying the filters but could not find a way to do this.
If not, it would be great if there was new option under the "Ignore" section of the project options that was selected by default but could then be removed to see the system objects in the database.
Thanks.
Doug
I have a number of common stored procedures that I have added to the master database and then marked with EXEC sys.sp_MS_marksystemobject sp_MySproc so that they are available to all databases on the server.
Is there a way to do this? I checked under the project options along with trying the filters but could not find a way to do this.
If not, it would be great if there was new option under the "Ignore" section of the project options that was selected by default but could then be removed to see the system objects in the database.
Thanks.
Doug
Comments
Thank you for your post into the forum.
SQL Compare does not compare system objects.
Therefore I have added the details of this forum post for SQL Compare to compare system objects and system databases to an existing feature request.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com