http://weblogs.asp.net/lkempe/archive/tags/SQL+Server/default.aspxTags: SQL ServerenCommunityServer 2007 SP1 (Build: 20510.895)http://weblogs.asp.net/lkempe/archive/2007/09/27/note-to-self-how-can-i-change-the-database-owner.aspxThu, 27 Sep 2007 07:39:41 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:4199273lkempelkempe1http://weblogs.asp.net/lkempe/rsscomments.aspx?PostID=4199273http://weblogs.asp.net/lkempe/archive/2007/09/27/note-to-self-how-can-i-change-the-database-owner.aspx#comments<p>From: <a title="http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm" href="http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm">http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm</a></p> <blockquote> <p><b>Answer:</b><br>You can use the <b>sp_changedbowner</b> system stored procedure to change the database owner.<br>Read about the <b>sp_changedbowner</b> stored procedure in SQL Server Books Online.<br>This is the example to make the user John the owner of the pubs database:</p><pre>USE pubs GO EXEC sp_changedbowner 'John' GO</pre></blockquote><img src="http://weblogs.asp.net/aggbug.aspx?PostID=4199273" width="1" height="1">Note to selfSQL Server