Sponsors

News

Jobping Laurent Kempé MVP JetBrains Academy Member Certified ScrumMaster

Contact

My status

View Laurent Kempé's profile on LinkedIn
XING
twitter
facebook


Xbox 360



Map

Locations of visitors to this page

.NET Dudes

Family

French .NET Dudes

Friends

Jobping

Links

Tech Head Brothers

Note to self - How can I change the database owner?

From: http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm

Answer:
You can use the sp_changedbowner system stored procedure to change the database owner.
Read about the sp_changedbowner stored procedure in SQL Server Books Online.
This is the example to make the user John the owner of the pubs database:

USE pubs
GO
EXEC sp_changedbowner 'John'
GO

Comments

rajbk said:

Another nice sp, which you may already know about, is the one for resolving orphaned owners:

sp_change_users_login 'Report'

support.microsoft.com/.../314546

Raj

# September 27, 2007 8:27 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)