GeekArticles
Database
SQL Server
Database
SQL ServerFinding the SQL Server Agent ErrorLog
Like the SQL Server ErrorLog, the SQL Server Agent ErrorLog is stored in a text file on the servers disk. It's usually in the subdirectory MSSQLLog under the location were the SQL Server Instance's code is installed. This article’s code is a UDF, udf_SQLA_ErrorLogFile that reads the registry to find the location of this log file.
Sponsored Links
Related Topics
Subscribe via RSS
SQL Server
- Naming Database Objects: Part II
- Trace Messages Part V: Trace Cleanup
- Naming Database Objects: Part I
- Multiple-Child Aggregation
- Creating SQL Tables for an Integrating Application Using Dexterity
- SQL Server 2005 Beta 2 Transact-SQL Enhancements
- .NET Rocks! - Brian Larson on SQL Server Reporting Services
- Computing the Trimmed Mean in SQL
- SQL Server 2000 Gains on Oracle
- Separator First Formatting (SFF)
