November 4, 2005 at 2:48 pm
I am using a join hint in a query within a stored procedure (INNER LOOP JOIN). We have an application that executes this stored procedure. The application is reporting an error because of the warning that is given when using a join hint. Does anyone know how to disable warnings from returning from a stored procedure execution, since our application is too stupid to know the difference.
The warning I am getting is:
“Warning: The join order has been enforced because a local join hint is used.”
A.J.
DBA with an attitude
November 5, 2005 at 6:50 am
Is the hint really necessary?
November 7, 2005 at 10:07 am
Gee thanks for your oh-so-f*&^ing-helpful post. Yes it is otherwise I would not have posted the question. I am not an idiot and do not need chumps like yourself second-guessing me. But thanks for your input, it was appreciated about as much as I appreciate losers who drive too slow in the fast lane while talking on their cell phones.
A.J.
DBA with an attitude
November 7, 2005 at 10:18 am
In that case, contact the creator/vendor of the application and have those errors checked on severity.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply