Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
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 [email protected].
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 [email protected]. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...