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

Quick Tip: No connection could be made because the target machine actively refused it

Your users get the below error when connecting to SQL Server that has been running fine all along.Reason:What could be the reason? Quite simple. Check to see if the service is running and start it if it is not!StackOverflow always has the answers for all the other kinds of configuration issues that might cause this … Continue reading Quick Tip: No connection could be made because the target machine actively refused it