asked
Getting the Error as Could not find Database ID
don't know what happened ...after connecting to server ..i am not able to see the databases in the server...if i click on databases folder i am getting the error as Could not find database ID 22. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred. (Microsoft SQL Server, Error: 913)
Start with the basics. Look in the error logs for any indication of problems. Any warnings or errors there can help start the search for a solution. Ask colleagues if they have been 'playing around'. Maybe someone did something they shouldn't have. What did you last do on the system. Are you the one who has done something that you shouldn't have? If you know which database has ID 22 - take a look if the data files are still on the disk. If so, try attaching the database. If that works, I would suggest running some checks on the database.
Have you tried to do **select * from sys.databases** in a query window?
It's possible that was the database designated as your default dB. Change your default to another dB and refresh.
