LISTING 1: Stored Procedure That Demotes a Log 
Shipping Database from Read/Write 
Mode to Read-Only Mode

USE master
GO
EXEC msdb.dbo.sp_change_primary_role
	@db_name = 'Pubscopy',
	@backup_log = 1,
	@terminate = 1,
	@final_state = 3,
	@access_level = 1