SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
102
Error 102: Incorrect Syntax Near – Finding the Real Line in a Long Batch
Error 102 rarely points at the true problem line. See how batch separators, reserved words and unclosed quotes shift the…
7202
Error 7202: Linked Server Missing From sys.servers and Ad Hoc Query Blocks
Error 7202 means the four-part name has no matching server and 7415 blocks ad hoc OPENROWSET access. Register the server…
208
Error 208: Invalid Object Name – Schema, Database Context and Collation
Error 208 rarely means the table is missing. Check the default schema, the database context, a case-sensitive collation and permissions…
0x84B10001
Setup Error 0x84B10001: SQL Server Installation Fails Before It Starts
Setup error 0x84B10001 is a catch-all. Read Detail.txt and Summary.txt to find the real inner code such as 0x80070002 or…
2627
Error 2627 and 547: Constraint Violations on Insert, Update and Delete
Error 2627 is a duplicate key, 547 a foreign key conflict and 515 a NULL in a NOT NULL column.…
0x851A0019
Setup Error 0x851A0019: Could Not Find the Database Engine Startup Handle
0x851A0019 is the startup handle failure and 0x851A001A the recovery handle one. Check the volume's sector size first, then the…
8152
Error 8152: String or Binary Data Would Be Truncated – Find the Column
Error 8152 hides which column overflowed on older builds. Use the SQL Server 2019 verbose message, or this query pattern,…
912
Error 912: Script Level Upgrade Failed After a Cumulative Update
Error 912 with 574 means an upgrade script failed and the instance is stuck. Start with trace flag 902, fix…
512
Error 512: Subquery Returned More Than One Value, and Related Query Failures
Error 512 means a scalar subquery matched several rows. Rewrite it with a join or TOP 1, and see how…
1603
MSI Error 1603 and 1618: SQL Server Tools and Update Installs Keep Failing
MSI error 1603 and 1618 usually mean another install is running or a cached MSI is missing. Clear the pending…
1205
Error 1205: Transaction Deadlocked on Lock Resources – Capture Then Cure
Error 1205 kills one session to break a lock cycle. Capture the graph from the system_health session, then fix index…
17051
Error 17051: The SQL Server Evaluation Period Has Expired – What To Do Now
Error 17051 stops the service dead 180 days after install. The only real fix is an edition upgrade with a…