
Ignoring Severity 10 errors
Brian,
You can't tell SLQ Server not to send the error. You have to ignore it in the client app (or
make sure it never happens).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
Quote:
> I'm working with a stored procedure that consistenly
> produces the error
> The index hints for table 'tablename' were ignored because
> the table was considered a fact table in the star join.
> This procedure is called by a com object that expects a
> record set in return, and the error message causes the
> application to crash. The recordset is still returned (I
> can run it fine in Query Analyzer). Is there a setting I
> can use when executing the query to have it ignore
> severity 10 errors like this one?
> I'm useing SQL Server 7.0
> Much thanks
> -Brian