when i use the backup sql statement to backup a database without a tape in the tape drive the sql analyzer is simply hanging instead of giving an error and come out(it gives an error message but the query still runs).i would like to trap this error and give a message to the administrator that the tape is not inserted.i cannot use notify by email,net send etc. in my environment...i would like to insert the error message to a table.
needing immediate help.....