Recently, I was facing some problem to check the proper error code in my procedure. Thanks to Sql Server 2005. It gives a great user friendly Schema & System table names. So This is the query by which we can see all the Error Codes, SELECT s.[error], s.severity, s.dlevel, s.[description], s.msglangid FROM sys.sysmessages s Now, I can use Try-Catch block in sq l server 2005 & can raise appropriate Error also depending upon the Error Code.
I love Programming, and Eager to learn New things Curious about Microsoft Products, Interested in Knowledge sharing. If you can dream IT, You can become it, If you can think IT, You can do IT, If you can believe it, you can achieve IT.