September 1, 2006 at 11:52 am
In my entire net in all sql servers installed Enterprise, Personal 'sa' has changed his database access and is dbo.
Is there a bug, virus, or any one has idea what happened wiyh all my sa configuration???
September 4, 2006 at 1:12 am
sa is a server login, dbo is a database owner which is a particular database user.
You need to understand that logins and database users are not the same.
If you look at logins on enterprise manager you should see that sa is still there.
September 4, 2006 at 2:07 am
Hi,
sa is by default system administrator. I don't understand your problem. See sa is login while dbo is db user. Please be presice on the problem.
regards
Pankaj
Pankaj Khanna
Database Administrator - SQL Server 2000
Keep hope to keep you intact...
September 5, 2006 at 11:37 am
Did you recently reboot the systems or detach/attach the databases? That can reset the database owner and sometimes it will be set to SA. Just change the owner to whomever you want it to be.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply