Msg 402 SQL Errors The data types varchar(max) and xml are incompatible in the add operator By deviprasad
Dead Lock Msg 1205 SQL Errors Transaction (Process ID ) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction. By deviprasad
Msg 8180 SQL Errors Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. By deviprasad
SQL Errors SQL Server Basics Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name “A” is a duplicate. By deviprasad
SQL Errors XML Msg 206, Level 16, State 2, Line 6 Operand type clash: int is incompatible with xml By deviprasad
sp_executesql SQL Errors System Stored Procedures Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1 By deviprasad
SQL Errors SQL Server 2000 SQL Server 2008 R2 SQL Server 2012 SQLServerPedia Syndication FIX – Cannot Restore SQL Server 2000 Backup on SQL Server 2012 By deviprasad
SQL Errors T-SQL Code Examples The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. By deviprasad
SQL Errors Cannot use the %ls granularity hint on the table “%.*ls” because locking at the specified granularity is inhibited. By deviprasad