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

Forcing owner (dbo)

Hi,

Whenever I try to sync my development to hosted SQL, I see that I always have differences. Because dbo is not forced as owner.

E.g. script:
PRINT N'Creating [dbo].[sp_SevDerTabsGet]'
GO
CREATE PROCEDURE sp_SevDerTabsGet

AS you see it prints with [dbo] but not executing with [dbo].

How can I force this?
Right now I need to open the script add them 1 by one.
sevder
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hi,

    This is caused by information that is inconsistent between the actual object definition, and the owner name as it appears in the database's system tables. This happens normally as the result of implicit ownership because the owner name was not specified when the object was created.

    In SQL 2000, the only way to fix this is to edit the stored procedure (alter or drop and recreate it), as you've found out.
    Brian Donahue
    0
  • sevder
    Hi,

    What about SQL 2005? I am using 2005.
    sevder
    0
  • Brian Donahue
    I don't know of a way to do this in SQL 2005, either. Unless someone else does?
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.