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)
 how to change Database owner?

Author  Topic 

fqiao70
Yak Posting Veteran

52 Posts

Posted - 2003-06-24 : 14:59:23
Hi, all
when I select property of my database thru Enterprise Manager, I see the owner of my database is not the user that I want. How do I change the owner????

Thanks

Shastryv
Posting Yak Master

145 Posts

Posted - 2003-06-24 : 16:14:50
Use sp_changedbowner

Go to Top of Page
   

- Advertisement -