Meta Data

[eggy168]

Hi, I am learning the DTS by a book. Something comes up that I need to check the Meta Data. When I open it in EM, it has an error message, "An error occurred while trying to access the database information. The msdb database could not be opened".

Can anyone please helps?

Thank You.

 

[mrdenny]

Use Query Analyzer to view the table.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[eggy168]

I can view the table in Query Analyzer, but I just want to know is it something wrong in the msdb database?
Thank You

 

[mrdenny]

Probably not. If there was the database would be in suspect mode.

If you can query the table in QA than the table is fine.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com