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" 😉