Tuesday, March 27, 2012

@@error can only capture limited error number?

Hi experts,
I'm quite with the using of @.@.error in Microsoft SQL 2000. For
instance,
Select * From Table1
If @.@.error <> 0
print 'Got error!!!'
I can have the @.@.error to capture the error number 208 (Invalid object name
'Table1') if the specific table is not found inside database.
Any hint?Read http://www.sommarskog.se/error-handling-I.html and
http://www.sommarskog.se/error-handling-II.html
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"LBT" <LBT@.discussions.microsoft.com> wrote in message
news:A2937AFF-D8E6-4414-A148-5FAD803C75F5@.microsoft.com...
> Hi experts,
> I'm quite with the using of @.@.error in Microsoft SQL 2000. For
> instance,
> Select * From Table1
> If @.@.error <> 0
> print 'Got error!!!'
> I can have the @.@.error to capture the error number 208 (Invalid object
name
> 'Table1') if the specific table is not found inside database.
> Any hint?

No comments:

Post a Comment