Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

database ownership issues Expand / Collapse
Posted Monday, November 5, 2012 8:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 12:46 PM
Points: 38, Visits: 65
I 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 ?

Post #1381105
Posted Monday, November 5, 2012 9:23 AM



Group: General Forum Members
Last Login: Yesterday @ 11:10 PM
Points: 2,997, Visits: 4,955
What error you got??
Post #1381155
Posted Monday, November 5, 2012 11:55 AM



Group: General Forum Members
Last Login: Today @ 5:30 AM
Points: 14,541, Visits: 38,386
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

and a basic command example:
--SQL2005 and before:
--assumes the current database is the one to change
EXEC sp_changedbowner 'sa'
--2008 and after
ON database::SandBox
TO sa


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!
Post #1381228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse