Reading the SQL Server log files using T-SQL
http://www.mssqltips.com/tip.asp?tip=1476
Reading the SQL Server log files using T-SQL - xp_readerrorlog
Using xp_readerrorlog.
If this extended stored procedure is called directly the parameters are as follows:
1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc…
2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
[...]
Using xp_ReadErrorLog in SQL Server 2005
http://www.sqlteam.com/article/using-xp_readerrorlog-in-sql-server-2005
* Parameter 1 (int), is the number of the log file you want to read, default is “0″ for current log. The extended stored procedure xp_enumerrorlogs will come in handy in determining what SQL server error logs or SQL server Agent logs exist and when they were created. NOTE: extended [...]
SQL Server Database Stack dump problem - External dump process return code 0×20000001.
If you have Stack dump problem with SQL Server - (External dump process return code 0×20000001. ) please check following link to fix the problem: http://support.microsoft.com/kb/960543
Message
External dump process return code 0×20000001.
External dump process returned no errors.
Message
Stack Signature for the dump is 0×0000000000000124
Message
* BEGIN STACK DUMP:
Message
***Unable to get thread context - no pss
