SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy…