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)
 Database Ownership

Author  Topic 

nishithrn
Yak Posting Veteran

58 Posts

Posted - 2003-06-19 : 10:00:03
Hello,

Is it possible for system admin. (sa) to take ownership of a database..?? (like Windows NT - ownership taken by administrator).

It is something like this. A particular user 'A' is given create database rights. He created a database 'ABC'. Now due to some reason, the ownership of user 'A' from 'ABC' database is required to be revoked. How can that be done .. ??

Thanks in advance
Nishith



Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-06-19 : 10:32:48
lookup sp_changedbowner

Jay White
{0}
Go to Top of Page
   

- Advertisement -