Msg 2540 means the system cannot self repair this error, usually corrupt metadata or system files. My fix order: restore the backup, DBCC repair, check hardware.
SQL SERVER – T-SQL Script to Attach and Detach Database
Detach Database operations remove a database from its instance without deleting its files. I preserve a recoverable backup before moving them.
SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today
I always thought a non-deterministic function was not allowed in a UDF, but GETDATE() works in SQL Server 2005. My UDF finds the day difference from today.
New Line in SQL Server Strings: CHAR(13) and CHAR(10)
A new line in SQL Server is a character in the string, not formatting. This post tests CHAR(13) and CHAR(10) on SQL Server 2025, shows how to find and remove line breaks in stored data, and shows why RTRIM leaves a trailing break and how a line break ends a single-line comment in dynamic SQL.
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
A step by step tutorial to create a T-SQL script that can copy database schema and all objects, like stored procedures, functions, triggers, tables and views.
Refactoring a Long Stored Procedure Into Readable Steps
Learn refactoring a long stored procedure with output baselines, named temp tables, dead-code removal, and two-way EXCEPT checks before release.
SQL SERVER – Find Monday of the Current Week
Find Monday of the current week with one line of T-SQL: DATEADD and DATEDIFF with the week part and GETDATE() give you the date.