Is it possible to specify from within a stored procedure to ignore the error produced by trying to drop a table although it doesn't exist yet?
For example, if you create and run the below it will output an error the first time it is run:
create procedure test_drop
drop table dropthis
create table dropthis(
Server: Msg 3701, Level 11, State 5, Procedure test_drop, Line 3 Cannot drop the table 'dropthis', because it does not exist in the system catalog.
Thanks in advance.