I am running SSMS 2008. When I connect to SQL Server running 2005 and attempt to open the databases folder I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find database ID 33. 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)
I ran sp_helpdb and searched the list of dbid's and ID 33 was not on the list. Has anyone run into this issue, or better yet resolved it?
Thank you in advance for your replies.