Microsoft KB Archive/298093

= FIX: BOL Incorrectly Demonstrates Usage of sp_change_primary_role with @job_id Parameter =

Article ID: 298093

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q298093



BUG #: 353875 (SHILOH_BUGS)



SYMPTOMS
The sp_change_primary_role topic in SQL Server 2000 Books Online incorrectly contains an example that demonstrates the usage of this stored procedure with the @job_id parameter.



RESOLUTION
@job_id is not a valid parameter for the sp_change_primary_role stored procedure. Use sp_change_primary_role with the following parameters:
 * @db_name
 * @backup_log
 * @terminate
 * @final_state
 * @access_level



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
The sp_change_primary_role stored procedure is used to remove the primary database from a log shipping plan. For more information on how to use the parameters mentioned above while switching a standby server to be the primary server, see the sp_change_primary_role topic in SQL Server 2000 Books Online.

For more information, also see the following topics in SQL Server 2000 Books Online:
 * How to Set Up and Perform Log-Shipping Role Change (Transact-SQL)
 * How to Remove Log Shipping (Enterprise Manager)
 * How to Aet Up Log-Shipping Monitor
 * Monitoring Log Shipping

Keywords: kbbug kbfix KB298093

-

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

© Microsoft Corporation. All rights reserved.