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...
A variety of businesses use a type of analysis called dependency risk analysis. This type of analysis determines whether one group of items in your business (e.g., products) is overly dependent on just one item of another group (e.g., customers)...
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to letters@sqlmag.com. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...