LISTING 3: Stored Procedure That Informs the
Monitor Server of the Role Change

USE master
GO
EXEC msdb.dbo.sp_change_monitor_role
	@primary_server = 'oahu\sql2k_1' ,
	@secondary_server = 'oahu\sql2k_2',
	@database = 'Pubscopy',
	@new_source = 'oahu\sql2k_2'