By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,569 Members | 1,386 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,569 IT Pros & Developers. It's quick & easy.

Ignore Some Errors

P: n/a
In my stored procedure I'm calling a buggy and flaky stored procedure
that comes from a third party. When I run my stored proceure from QA,
I'm getting a whole buch of errors raised inside the third party one.
Is there any way I could just ignore them, so that if I run my SP from
QA, only errors from my code, if any, show up?

TIA

Jan 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Assuming that you are working on SQL2k (please post the version you are
using in the next post) there are some errors which can be caught. For
more information about error handling read further in:
http://www.aspfaq.com/show.asp?id=2470

HTH, Jens Suessmeyer.

Jan 25 '06 #2

P: n/a
Ford Desperado (fo************@yahoo.com) writes:
In my stored procedure I'm calling a buggy and flaky stored procedure
that comes from a third party. When I run my stored proceure from QA,
I'm getting a whole buch of errors raised inside the third party one.
Is there any way I could just ignore them, so that if I run my SP from
QA, only errors from my code, if any, show up?


In SQL 2000, you are pretty lost. In SQL 2005 you can use the new
TRY-CATCH mechanism.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.