DBO Owner vs. other users as the owner
Posted on 2004-08-27
I manage an MSSQL 2000 Windows 2000 server with about 100 databases on it for various customers. All of these customers manage their databases remotely via Enterprise Manager and scripts on their Web Sites that connect to the server. Each database has a unique login that is in the public and db_owner roles of a particular database. The problem is that some customers complain that when they create tables or transfer them from elsewhere with DTS, the owner is either dbo or the custom user for their database. Which user is the owner varies based on reasons I am not aware of. Some customers complain they cannot do certain things because the owner is dbo and others complain about the owner not being dbo.
Can someone explain what causes this discrepancy of owner and also what limitations this puts on functionality either way?
Thanks in advance,