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

  • April 9, 2014 at 1:36 am

    #1704392

    Finally I was able to fix this issue...:-D

    The steps are as follows-

    -Take the backup of master database

    -Start SQL Server in single user mode using –m switch

    -Login to SQL server Dedicated Administrator connection

    -Update value of ‘category’ field to 23040 from existing value 23056 in ‘sys.sysdbreg’ table for <dbname> database

    -Start SQL server in normal mode