Many people search for DBCC ROWLOCK in SQL Server 2005. It is deprecated, since row locking is on automatically. I also link the list of discontinued features.
SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded
ERROR 1222: Lock request time out period exceeded. Find the blocking transaction with DMVs, and what to change when you are not allowed to kill it.
SQL SERVER – ERROR Messages – sysmessages error severity level
SQL Server ERROR Messages explained: each has a number, a severity level and a state from 1 to 127, and all of them are stored in the sysmessages system table.
SQL SERVER – 2005 Take Off Line or Detach Database
To take off line a database in SQL Server 2005, use ALTER DATABASE SET OFFLINE with ROLLBACK AFTER 30 SECONDS or ROLLBACK IMMEDIATE instead of sp_dboption.
SQL SERVER – TRIM() Function – UDF TRIM()
SQL Server 2005 has LTRIM() and RTRIM() but no TRIM() function, so I wrote a simple UDF for SQL Server 2000 and 2005 that trims both sides. Video included.
SQL SERVER – Six Properties of Relational Tables
The six properties of relational tables explained: atomic values, values of the same kind, unique rows and more, with the benefit of each one.
SQL SERVER – 2005 Collation Explanation and Translation
How to read a SQL Server 2005 Collation name like Latin1_General_CI_AS, check which collation you have, and avoid collation conflict errors.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.