Anoying user dbo - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Anoying user dbo

Author

Topic

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2005-07-18 : 19:38:19

the database user dbo has an NT user name assigned to it, now I have to drop this NT user but I can't cause the database thinks I am trying to drop user dbo

Name Login Name
dbo MyDomain\NtUserID

How do I correct this

You can do anything at www.zombo.com

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-18 : 20:30:51

look up sp_changedbowner in BOL.

ok, I did it for you: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_30s2.asp

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources