Monthly Archives: December 2005

SQL 2005: Use TRY/CATCH to handle and log errors

SQL 2005 supports TRY/CATCH to handle errors. It has a TRY block (BEGIN TRY/END TRY) and a CATCH block (BEGIN CATCH/END CATCH). If any exception happens in the try block, the execution will jump to the catch block. In the … Continue reading

Posted in SQL server 2005 | 1 Comment

Query editor mistery

If a statement is terminated by ascii 0D only, SQL 2000 query analyzer can parse it correctly. But in SQL 2005 SSMS query editor, it will give an error. Run the following code in SQL 2000 and SQL 2K5, copy … Continue reading

Posted in SQL server 2005 | Leave a comment

SQL 2K5 edtions and features

The link http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx lists the features, scalibility, high availibility etc for each editions.     It’s also in BOL but with more details: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm      

Posted in SQL server 2005 | Leave a comment