Error 1702, CREATE TABLE failed, happens when a table goes past the 1024 column limit in SQL Server 2000. The fix is to cut the columns to 1,024 or fewer.
SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
An SSIS package fails with Error 3902: the COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Two fixes, one is RetainSameConnection set to true.
SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System
Few days ago, I have received email from users asking question :How to run 64 bit SQL SERVER 2005 on 32 bit operating system?
SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String
A simple UDF, ExtractInteger, to extract only numbers from string input. I test it with a phone number that also has letters in it.
SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling
SQL Server 2005 brings TRY…CATCH for error handling, so you no longer check @@ERROR after every statement. Here is how the TRY and CATCH blocks work.
SQL SERVER – 2005 – Silent Installation – Unattended Installation
Silent installation of SQL Server 2005 in two steps: an .ini file built from template.ini, then setup.exe with /qn or /qb. Plus tips to test it.
SQL SERVER – SP Performance Improvement without changing T-SQL
Two easy ways to improve SP performance without changing T-SQL: do not prefix stored procedures with sp_, and call them by the fully qualified dbo name.