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

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...