November 23, 2004 at 3:10 pm
I just wanted to add a comment on dbo ownership of database objects. Not having dbo as owner makes the removal of sql logins a nightmare since it won't happen until all objects owned by the login are also deleted.
Just another reason to follow Andy Warren's Best Practices.
November 26, 2004 at 8:00 am
This was removed by the editor as SPAM
November 26, 2004 at 9:13 am
This is true, although it's a good thing. Don't want objects to exist without an owner.
November 29, 2004 at 7:06 am
Dbo ownership can also be a challenge when you purchase 3rd party applications. We are currently working with a vendor whose scripts don't designate dbo so objects are owned by whomever executes them. Luckily I noticed this on the test box and can prevent the production database from being a potential mess 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply