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
skip to main |
skip to sidebar
RSS Feeds
Follow us on Twitter!
Find out what I'm doing. Follow Me on Twitter.
Abhijit's World of .NET Blog
Saturday, August 15, 2009
Follow us on Twitter!Find out what I'm doing. Follow Me on Twitter.
Labels
- .NET (1)
- .NET 4.0 (10)
- ASP.Net (2)
- ASP.NET (12)
- asp.net 4.0 (2)
- ASP.NET 4.0 (1)
- Awards (2)
- C# (8)
- C# 4.0 (3)
- code (1)
- codeproject (5)
- Debugging (2)
- Enterprise Library 4.1 (1)
- General (21)
- IIS (1)
- IntelliTrace (2)
- Microsoft ASP.NET Web Site (4)
- MSDN (1)
- Multithreaded Debugging (1)
- MVC (1)
- MVC Framework (1)
- MVP (3)
- My Articles (15)
- Parallel Debugging (1)
- RenderingMode (1)
- SQL Server 2005 (6)
- VideoTutorial (1)
- View State (1)
- Visual Studio 2010 (9)
- VS 2010 (1)
- VSX (1)
- Web Services (1)
- WPF (1)
ASP.NET Books
Copyright 2009
Abhijit's Blog. Powered by Blogger
Blogger Showcase - Submit Your Blog Blogger Templates created by Deluxe Templates
Wordpress theme by Site5
Blogger Showcase - Submit Your Blog Blogger Templates created by Deluxe Templates
Wordpress theme by Site5
1 comments:
Thank you good Article.
I 've a question.
we can do this in Sqlserver2000 ?
BEGIN TRY
DECLARE @Intval int;
SET @Intval = 1/0; -- Devide by Zero Error
END TRY
BEGIN CATCH
RAISERROR (50009, 11, 1); -- 50009 is our pre-defined error that are stroed using sp_addmessage
END CATCH;
Post a Comment