Link to home
Start Free TrialLog in
Avatar of Camillia
CamilliaFlag for United States of America

asked on

stored proc runs fine but gives a warning

This is related to the dynamic stored proc question i asked here;
https://www.experts-exchange.com/questions/22472527/Print-statement-inside-dynamic-sql.html?cid=239&anchorAnswerId=18793550#a18793550

It works fine, i get results back but i also get this warning. The stored proc returns 1 or more rows. Should I be worried about it?

---
Return Code = 0


SQL State: 0100C
Vendor Code: 466
Message: [SQL0466] 1 result sets are available from procedure WSP_GETRESULTS in VQUEDTA020. Cause . . . . . :   Procedure WSP_GETRESULTS in <dbname> was called and has returned one or more result sets. Recovery  . . . :   None.

SQL State: 01S02
Vendor Code: -99999
Message: Option value changed.

Statement ran successfully, with warnings   (343 ms)

ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Camillia

ASKER


well, good. Thanks.