sql server programming: Check out sp_changedbowner and ALTER DATABASE in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


[quoted text, click to view]
Hey

I've created a simple database in Sql Server 2005 Express. I created the
database using Microsoft Sql Server Management Studio Express...

After creating the database, I took a full backup of the database and
deleted the database, because I wanted to learn about doing database
restore...

The problem when restoring the database is that the dbowner is assigned to
another user, I want another user to be the dbowner... How do I specify who
should be dbowner?

Jeff

Hey

I've created a simple database in Sql Server 2005 Express. I created the
database using Microsoft Sql Server Management Studio Express...

After creating the database, I took a full backup of the database and
deleted the database, because I wanted to learn about doing database
restore...

The problem when restoring the database is that the dbowner is assigned to
another user, I want another user to be the dbowner... How do I specify who
should be dbowner?

Jeff