"LBT" <LBT@discussions.microsoft.com> wrote in message
news:A2937AFF-D8E6-4414-A148-5FAD803C75F5@microsoft.com...
> Hi experts,
>
> I'm quite confused 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?