SQL Server: A More Flexible xp_ReadErrorLog That Reads All Error Logs Including Archives

I am sure that all of you are already familiar with the extended stored procedure xp_ReadErrorLog and its less flexible and published equivalent sp_ReadErrorLog (which takes less parameters) for reading the SQL Server Error Log. xp_ReadErrorLog - To read current error log: The extended stored procedure xp_ReadErrorLog is very useful. It helps with reading the … Continue reading SQL Server: A More Flexible xp_ReadErrorLog That Reads All Error Logs Including Archives

Advertisements

SQL Server – Do temporary work with temporary Stored Procedures & tables

SQL Server temporary tables and global temporary tables: For temporary work, we use temporary tables and global temporary tables. There is nothing complex about their usage. Use Temp tables if only your sessions needs access to the data in the temp table using the #TempTable naming format. To share data in a temp table across … Continue reading SQL Server – Do temporary work with temporary Stored Procedures & tables