RE: defaulting newly created objects to DBO

From: Jeff L. (anonymous_at_discussions.microsoft.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 11:11:08 -0800

I am puzzled about this too. I am about to start using sp_addalias though.

I think Microsoft needs to think this area through a little better. I know sp_addalias may go away some day, but the current version doesn't handle this well.

In test, we like to give developers logins that link to the dbo user so that we can have the system enforce all objects getting created by dbo. Then when we create these in production we can be comfortable that the user is the same and any code that references the user will always be "dbo" and not "joe_developer".

While it is best practice for developers to always reference user name with objects, in practice it is harder to enforce without the system to do it for us. Our company employs consultants regularly and they all seem to have different habits we end up having to work on with them.