<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Changing the owner of a database</title><link>http://sqlblog.com/blogs/louis_davidson/archive/2007/12/05/changing-the-owner-of-a-database.aspx</link><description>Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>re: Changing the owner of a database</title><link>http://sqlblog.com/blogs/louis_davidson/archive/2007/12/05/changing-the-owner-of-a-database.aspx#3700</link><pubDate>Wed, 05 Dec 2007 13:59:14 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:3700</guid><dc:creator>jerryhung</dc:creator><description>&lt;p&gt;Funny post&lt;/p&gt;
&lt;p&gt;I actually used sp_changedbowner just yesterday, and saw the ALTER AUTHORIZATION alternative as well&lt;/p&gt;
&lt;p&gt;I changed owner because the &amp;quot;Properties&amp;quot; window won't show on the database, as the database owner no longer exists.&lt;/p&gt;
</description></item></channel></rss>