How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
The August 2008 release of SQL Server 2005 Best Practices Analyzer (BPA) checks your Windows and SQL Server settings against Microsoft best practices.
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
If you are receiving the following error related to connection to SQL Server, this blog is for you.
SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000
Still on SQL Server 2000? Microsoft released a security update for SQL Server 2000 Service Pack 4 and MSDE 2000. Get the download link here.
SQL SERVER – Introduction to Log Viewer
The SQL Server 2005 Log Viewer shows SQL Server error logs, Agent logs, Database Mail and Windows event logs in one place, ready to filter and export.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
SQL Server has many features you can turn on or off. Use sp_configure to display or change global configuration settings, including the advanced options.
SQL SERVER – 2008 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.