FIX: BOL Incorrectly Demonstrates Usage of sp_change_primary_role with @job_id Parameter (298093)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbfix KB298093
©2003 Microsoft Corporation. All rights reserved.