Error 21776 - dbo account
Date: 10 Nov 2003 10:22:30 -0800
I moved some database around and am now getting an error claiming
there is no dbo name in the users collection. Several databases had
no db-owner specified so i pointed them to sa account using
Same thing, problem remains.
Any ideas on how to fix?
- Re: Change dbo
... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
- Re: Developer design Best Practices
... > test - they develop them and then I move them, and the owner is dbo. ... > There is NO DBO User in our dev database!! ... just means it is owned by the database owner, ... to have a busy dba monitoring development servers. ...
- Re: db_owner role in SQL 2k
... I do the select user_nameand get dbo ... Do you mean EM lists VDW as the owner of the database? ... I presume then that you are logged in as tfs. ... So my guess is that the login tfs is in the sysadmin role on the server, ...
- Re: Groups for dbo
... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ...
- Re: Change UDF Owner
... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...