Owner and Store Procedures

Daniel HandleyDaniel Handley Posts: 214
edited February 10, 2005 6:26AM in SQL Compare Previous Versions
Hi Marto
Because the store procedures have different owners the are treated by SQL as different objects.
SQl Compare picks them up as different objects, reports this back, and will create the missing objects in each database.

This has happened because when the store procedures were created the owners weren't specified and thus have either picked up the default dbo, or the user creating them.

To correct this you will have recreate them specifying the owner.


Please note that this can also happen with other object.

Daniel Handley
Red Gate Software Ltd
Daniel Handley
Red Gate Software Ltd
This discussion has been closed.