you can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;
the BOL Links are here for the explanation and the code:
Changing the Database Owner
ALTER AUTHORIZATION (Transact-SQL)
and a basic command example:
--SQL2005 and before:
--assumes the current database is the one to change
EXEC sp_changedbowner 'sa'
--2008 and after
ALTER AUTHORIZATION
ON database::SandBox
TO sa
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!