Is it possible using Try-Catch in SQL Server 2000?
SQL Server 2000
No, it is not possible.
This was only from Sql Server 2005
Check TRY...CATCH (Transact-SQL) and check the Other Versions