Microsoft KB Archive/291160

= FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE =

Article ID: 291160

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q291160



BUG #: 352563 (SHILOH_BUGS)



SYMPTOMS
The SQL Server 2000 Books Online documentation is incorrect regarding the default value for the @terminate parameter for the sp_change_primary_role stored procedure in the msdb database.



CAUSE
The &quot;sp_change_primary_role&quot; topic in SQL Server Books Online incorrectly states that the default value is 1.



RESOLUTION
The correct default value for the @terminate parameter is zero (0). If processes must be terminated at the time of execution of the sp_change_primary_role stored procedure, then you must specify a value of 1 for the @terminate parameter.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000. This problem has been resolved by the SQL Server 2000 Books Online Refresh, which can be obtained from the following Microsoft Web site:

http://www.microsoft.com/downloads/release.asp?ReleaseID=31343



MORE INFORMATION
A default value of zero (0) for the @terminate parameter means that the processes connected to the database when the stored procedure is executed, will not be terminated. If a value of 1 is specified for the stored procedure, all existing connections to the database are terminated and all pending transactions are immediately rolled back.

Keywords: kbbug kbfix KB291160

-

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

© Microsoft Corporation. All rights reserved.