Monday 10 April 2006

Why Can't I view all the logs in SQL 2005 Log Viewer ??

What I thought would be a cool feature in SQL Server 2005 is the Log Viewer.
A little way down the track I'm begining to be very disillusioned. Take a look at the following screenshoots and see how where you open the Log Viewer from seems to affect what you can select to view.
#1 - Under Management folder, right-clicking Database Mail and choosing 'View Database Mail Log' presents me with the following.
Database Mail Log
Job History Log
Maintenance Plan Log
SQL Agent Logs
Windows Event Logs (Note: Even though we're running Windows Server 2003 it's still Windows NT Event Logs)
No SQL Server Error Logs are available fior viewing





Log Viewer #2 Under SQL Server Agent\Error Logs, double-clicking one of the logs presents me with the following.
Database Mail Log
SQL Agent Logs
Windows Event Logs
No SQL Server Error Logs are available fior viewing
No Job History Logs are available fior viewing
No Maintenance Plan Logs are available fior viewing





Log Viewer #3 Under Managment\SQL Server Logs, double-clicking one of the logs presents me with the following.
Database Mail Log
SQL Agent Logs
SQL Server Logs
Windows Event Logs
No Job History Logs are available fior viewing
No Maintenance Plan Logs are available fior viewing





Now this is a pretty poor showing for a release product. Much evidence of rushing out the door to meet a deadline. Hopefully these "glitches" will be recitified with coming service packs and make the toolset actually usable.

No comments: