SQL Server Books Online (BOL) doesn't document a way to view error logs from your application. But two undocumented extended stored procedures in SQL Server 2000 and 7.0—sp_enumerrorlogs and sp_readerrorlog—let you examine error logs so that you ...
Editor's Note: Send your SQL Server questions to Microsoft's SQL Server development team at questions@sqlmag.com.
What kind of stored procedure can I use to transfer data from a text file to SQL Server?
Listing 1 shows a stored procedure th...