Microsoft KB Archive/201416

= BUG: @@OPTIONS Does Not Revert to Pre-Procedure Setting =

Article ID: 201416

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q201416



BUG #: 17541 (SQLBUG_65)



SYMPTOMS
If the SET statement is used inside a stored procedure or trigger to set an option, it will revert back to its former setting properly after the stored procedure or trigger execution is completed; however, the @@OPTIONS global variable remains set.

For example, if you execute sp_helpdb, which sets NOCOUNT on, and check @@OPTIONS after that, the output will show 512 for NOCOUNT although the message stating how many rows were affected by the statement will be there.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.

Additional query words: golden sp1 sp2 sp3 sp4 sp5 st proc sproc sp

Keywords: kbbug kbpending KB201416

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.