FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE (291160)
The information in this article 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 "sp_change_primary_role" 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:
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.
| Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
|---|
| Keywords: | kbbug kbfix KB291160 |
|---|
|