Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
louisx123
Starting Member
1 Post |
 Posted - 2010-09-28 : 21:00:08
|
| I've seen other posts about this on the Internet, but no solution. I have SQL Server Express 2008 and SQL Server Management Studio. The SSMS was working for a while, and I always launch it from my Windows Vista PC as Administrator, but now when I try to access an object in the object explorer I receive this message (and just a note, the databases all are working fine and are accessible via Visual Studio, and the applications using the databases are working fine):"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------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476----------------------------" |
|
|
|
|
|
I cannot access objects in SSMS