Hi,

I am trying to perform the role change to make the current secondary server
the current primary server. Using following TSQL

EXEC sp_change_primary_role
@db_name = 'Customers',
@backup_log = 1,
@terminate = 0,
@final_state = 2,
@access_level = 1
GO


Am getting the following error
Could not find stored procedure 'sp_change_primary_role'.

Am using sql server 2000. Is there any alternate way i can change the
secondary server as my primary server.

Thanks
Jessy




This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
MS Sql Server LazyDBA home page