Change Admin User

[Dexter]

Hi,
Thanks in advance for your help. I need to change the Administrative
user/owner of BCM. The current person in this role has left the organization.
We need another user to take over this role and delete the old admin user.
I can't seem to find how to do this? Any ideas?

Thanks
Dexter Southerland

 

[Luther Blissett]

Hi,
Thanks in advance for your help. I need to change the Administrative
user/owner of BCM. The current person in this role has left the organization.
We need another user to take over this  role and delete the old admin user.  
I can't seem to find how to do this? Any ideas?

Thanks
Dexter Southerland

A user with admin privileges on Sql can run sp_changedbowner ans set a
new owner.
http://technet.microsoft.com/en-us/library/ms178630.aspx