My New Article : Overview of Error in SQL Server 2005 Handling

Today I have published another article on Error Handling in SQL Server 2005. This is all about how we are going to handled errors and exception in T-SQL. I have described basic of  @@ERROR and TRY-CATCH Block with proper example. If you are really intereseted, then please read my article here, Overview of Error Handling in SQL Server 2005

Please give your suggestion and feedback .


Written by Abhijit Jana

I am a Modern and Cloud App Development Consultant working at Microsoft. Presently I am focusing on adopting and delivering world class solution on N+1 Technologies, where I mainly drive engagements on Universal Windows Platforms, Microsoft Azure, IoT and Cross Platform and Device related application Development. I am a former Microsoft MVP, Author of Kinect for Windows SDK and HoloLens BluePrints book and Run Daily .NET Tips . To know more about me click here.


  1. Hello abhijit i tried to practise the try catch block but its not working its displaying the message that

    Msg 195, Level 15, State 10, Line 6
    ‘ERROR_MESSAGE’ is not a recognized function name.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s