Ignoring Severity 10 errors 
Author Message
 Ignoring Severity 10 errors

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



Sun, 04 Apr 2004 07:44:24 GMT
 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



Sun, 04 Apr 2004 14:50:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 17824, Severity 10 State 0

2. Stop processing if an error with severity of 10 or geater

3. Error : 60004, Severity: 10, State: 1 ???

4. Error 17824, Severity 10, State 0

5. Error 17824, Severity 10, State 0

6. 97/09/05 15:30:10.76 spid18 Error : 602, Severity: 21, State: 15

7. Error 17824, Severity 10, State 0

8. ERROR: ODBC Sybase 10 error 80040e31 via asp or VB

9. ERROR: ODBC Sybase 10 error 80040e31 via asp or VB

10. Clipper error/Term 10 Print Error?

11. Error: 3314, Severity: 21, State: 2 / Error while undoing logged operation in database

12. SQL 7 Error Message: Error: 1105, Severity : 17, State 2


 
Powered by phpBB® Forum Software