How can we help you today? How can we help you today?

Schema name missing from CREATE PROCEDURE

FIrst off, I love SQL Compare. Been using it for years. I came across something I haven't seen before and serached for answer but can't find it.

Here's a snipet of a compare script that was generated:

PRINT N'Creating [dbo].[Org_Insert]'
GO
CREATE PROCEDURE Org_Insert

The problem is that the schema ("[dbo].") is not being added to the actual script command and SQL is assigning the new stored procedure to my logged in user schema and not to dbo. How can I make SQL Compare force the schema by including it in the command?

I want this:
PRINT N'Creating [dbo].[Org_Insert]'
GO
CREATE PROCEDURE [dbo].[Org_Insert]
rosborn
0

Comments

1 comment

Sort by
  • peter.peart
    Hi there,

    I have tested this out myself, and you are right in the SQL Compare doesn't use the owner when creating the proc as you would like. I have added this as a request in our systems under SC-4569, and will hopefully be included in a future release of the tool.

    Pete
    peter.peart
    0

Add comment

Please sign in to leave a comment.