Posted by SQL Enthusiast
Article by our editor
SQL Server logs can be searched using SQL as an alternative to using the Log File Viewer in SQL Server Management Studio. This method uses an undocumented, but widely used, system stored procedure called xp_readerrorlog. This can be a lot quicker than loading the error log into the Log File Viewer.
Comments • Read full article »
One thing I like to do occasionally, or when "inheriting" a new SQL server is to check which users have sysadmin privileges. As these users have access to perform any activity in SQL Server it’s important to keep the number of these users to a minimum especially on production systems.
Comments (7) • Read full article »
More SQL questions »