Post reply

database ownership issues

  • November 5, 2012 at 8:17 am

    #264470

    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 ?

    thanks

  • November 5, 2012 at 9:23 am

    #1556113

    What error you got??

  • November 5, 2012 at 11:55 am

    #1556178

    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!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply