Turn warning message off in a store procedure 
Author Message
 Turn warning message off in a store procedure
How do you disable the warning?
whenever i run this sp,  it's always returning this warning message on the
first line.

--------------------------------------------------------
Warning: The join order has been enforced because a local join hint is used.

                                            -mike



Mon, 07 Nov 2005 16:21:48 GMT
 Turn warning message off in a store procedure

Did you try:

SET ANSI_WARNINGS OFF


Quote:
> How do you disable the warning?
> whenever i run this sp,  it's always returning this warning message on the
> first line.

> --------------------------------------------------------
> Warning: The join order has been enforced because a local join hint is
used.

>                                             -mike



Mon, 07 Nov 2005 16:44:44 GMT
 Turn warning message off in a store procedure
Aaron,
there is a problem if i turn it on.

 Server: Msg 7405, Level 16, State 1, Line 1
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable
these options and then reissue your query.



Quote:
> Did you try:

> SET ANSI_WARNINGS OFF



> > How do you disable the warning?
> > whenever i run this sp,  it's always returning this warning message on
the
> > first line.

> > --------------------------------------------------------
> > Warning: The join order has been enforced because a local join hint is
> used.

> >                                             -mike



Mon, 07 Nov 2005 17:12:31 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Turning off SQL warning messages

2. Turning off warning message

3. Turning off stored procedures

4. Turn Off Trigger Execution from a Stored Procedure?

5. How to Turn off Stored Procedure Encrytion?

6. Turn off select inside a stored procedure

7. Turn Off Generate Temporary Stored Procedures

8. Turning off AutoCommit in Stored Procedures

9. Turn off system warning

10. turning off sql warnings

11. turn off adodc warning

12. "lazy"stored procedures-- WARNING: LONG MESSAGE


 
Powered by phpBB® Forum Software