quote:
We strongly advise dbo ownership of all objects for our environment. From time to time there is a "special circumstance" where non-dbo ownership is a good thing. Those cases are few and far between, however. Another issue in this vain is being roled as DBO (via the EM GUI or sp_addrolemember) vs. sp_addalias. When you role a user's login (say developer12) to db_owner any object created by that user will be owned by developer12 instead of dbo. We therefore alias developers in dev environments. It works well, but as a production dba you need to remember to sp_dropalias when the db gets moved to production. Microsoft's view about this issue is made in Q234181--they say they prefer roles over aliases, but myself and many others disagree and prefer aliases. For now, given Microsoft's direction of the moment, we try to avoid aliases in production for SQL 7 and beyond.