My New Article : A Closer Look Inside RAISERROR – SQLServer 2005

Today,  I have published another article on fundamental of RAISERROR in SQL Server 2005. Its all about  internal of RAISERROR, how to use it,  sp_addmessage, use them inside TRY-CATCH etc. If you really interesed, Here is my complete article

A Closer Look Inside RAISERROR – SQLServer 2005

My Articles, SQL Server 2005

Written by Abhijit Jana

Technology Leader, Technical Strategist, Solution Architect, Development Consultant and a Trusted Technology Advisor with more than 12 years of experience in the IT industry with expertise in Development, Architecting, Engineering, Consulting, and Services Delivery. I am a former Microsoft MVP, Author of "Kinect for Windows SDK Programming Guide" and "HoloLens BluePrints" books and founder of The Daily .NET Tips . To know more about me visit "About Me" page.

One comment

  1. Thank you good Article.

    I ‘ve a question.
    we can do this in Sqlserver2000 ?
    DECLARE @Intval int;
    SET @Intval = 1/0; — Devide by Zero Error
    RAISERROR (50009, 11, 1); — 50009 is our pre-defined error that are stroed using sp_addmessage


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

%d bloggers like this: