5

Is it possible using Try-Catch in SQL Server 2000?

Improve this question
1
  • 4
    No. Only in 2005 and 2008, 2008 R2. Commented Dec 24, 2010 at 6:15

5 Answers 5

Reset to default
9

No, it is not possible.

This was only from Sql Server 2005

Check TRY...CATCH (Transact-SQL) and check the Other Versions

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

6

No. Try Catch block was introduced in SQL SERVER 2005.

Following article shows how you can use @@ERROR to check for errors.

Understanding error handling in SQL Server 2000

Improve this answer

Comments

4

Instead you can user @@Error..

check this article about error handling

Improve this answer

Comments

1

@@ERROR is a variable updated by the SQL Server database engine after each statement is executed on the server. We can see by Print @@Error

Improve this answer

Comments

0

No Try Catch Was introduced 2005 and later version ,,,you have to use @@Error for handling your exception

Improve this answer

1 Comment

Don't you think it is a little bit late? Like 4 years?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.