Owner and Store Procedures
Daniel Handley
Posts: 214
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.
CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS
Please note that this can also happen with other object.
Daniel Handley
Red Gate Software Ltd
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.
CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS
Please note that this can also happen with other object.
Daniel Handley
Red Gate Software Ltd
Daniel Handley
Red Gate Software Ltd
Red Gate Software Ltd
This discussion has been closed.
