Home Forums SQL Server 2005 Administering User database moved to "System Databases" container RE: User database moved to "System Databases" container

  • March 28, 2014 at 9:14 am

    #1701175

    deepak.bisht (3/21/2014)

    I need help.

    One of my user database is somehow moved to "System Databases" container in SQL Server Management Studio(I don't know how it moved).

    i.e. it is visible in Enterprise Manager the database is visible under Databases> System Databases (along with master, msdb, model and tempdb).

    Now, I am not able to move it back to user databases section. I have tried drag and drop, checked DB properties etc. but it is not moving back.

    I am using SQL server 2005 Ent edition SP2

    Regards,

    Deepak Bisht

    As pointed out already, this is a distribution database not a user database. They are designed to sit under the system database container

    What does the following query return?

    exec sp_helpdistributor

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉