Error Handling not workinh after select a bad table

Hi guys,
I have a SP that is executing a simple task, and I=B4m forcing an error,
but the SQL Server is not catching the error, please help me.
The code is:
insert into table1
select * from table2_bad
print @.@.error
Notes:
The table2_bad is not valid in the database, so the sql show an error
saying that the table isnt create of something... but the variable
@.@.error isnt filled.=20
Do you know why'
Thanks!Answered in .programming. Please do not post the same message independently
to multiple newsgroups.

Error Handling not workinh after select a bad table

Hi guys,
I have a SP that is executing a simple task, and I=B4m forcing an error,
but the SQL Server is not catching the error, please help me.
The code is:
insert into table1
select * from table2_bad
print @.@.error
Notes:
The table2_bad is not valid in the database, so the sql show an error
saying that the table isnt create of something... but the variable
@.@.error isnt filled. Do you know why'
Thanks!Answered in .programming. Please do not post the same message independently
to multiple newsgroups.