Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006

    Unanswered: ignore errors in SqlServer 2000 (try/catch)

    Is there any way to emulate the try/catch mechanism that SqlServer2005 provides using SqlServer2000?
    Or more simply,
    Is there any kind of IGNORE_ERROR or CONTINUE_ON_ERROR setting for SqlServer 2000?


    - John

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Asked this one myself a few months ago John. I imagined that there wasn't but thought I would ask anyway. Guess what?

    No - there isn't
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    True, but that doesn't mean that you can't get there from here...

    You can easily launch a SQL Job from Transact-SQL. You can launch extended stored procedures (although they are more challenging to write). You can usually launch a server executable which can be written using anything that can run from the command line (no GUI allowed).

    While there isn't an easy answer, there are still several answers available.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts