InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:12:36 GMT20http://www.sqlservercentral.com/Forums/Topic1381105-1550-1.aspxyou can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;the BOL Links are here for the explanation and the code:[url=http://msdn.microsoft.com/en-us/library/ms190909(v=sql.105).aspx]Changing the Database Owner[/url][url=http://msdn.microsoft.com/en-us/library/ms187359(v=sql.105).aspx]ALTER AUTHORIZATION (Transact-SQL)[/url]and a basic command example:[code]--SQL2005 and before:--assumes the current database is the one to changeEXEC sp_changedbowner 'sa' --2008 and afterALTER AUTHORIZATION ON database::SandBox TO sa[/code]Mon, 05 Nov 2012 11:55:52 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1381105-1550-1.aspxWhat error you got??Mon, 05 Nov 2012 09:23:00 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1381105-1550-1.aspxI have my databases user and default schema set for 'dbo' but if i import a new database , and look at the security its user and default schema fields are empty and if i try to assign sa as db_owner of this database i get an error.how can i make this database after import user=dbo and 'default schema'=dbo and have sa user teh dbowner of this database .. .like my all other databases ?thanksMon, 05 Nov 2012 08:17:27 GMTsahmad43