Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
Error 130 says you cannot perform an aggregate function on an expression containing an aggregate, like AVG(COUNT()). A derived table gets around it.
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.
SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection
Fix for HResult 0x2, Named Pipes Provider: could not open a connection to SQL Server. Enable TCP/IP and Named Pipes in SQL Server Configuration Manager.
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
Error 2501, cannot find a table or object with the name, is a common beginner error. Check the database with USE, the spelling and case, and the owner name.
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
Error 1101, could not allocate a new page because of insufficient disk space in filegroup. Free up hard disk space and turn on AUTOGROW for the filegroups.
SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
Msg 3159 says the tail of the log was not backed up, then Msg 3013 ends RESTORE DATABASE. A script that worked in SQL Server 2000 failed in 2005, and here is why.