logSyncThenSetUsersToHotSite

IF EXISTS (SELECT * FROM sysobjects 
           WHERE id = OBJECT_ID('dbo.logSyncThenSetUsersToHotSite') 
           AND sysstat & 0xf = 4)
	DROP PROCEDURE dbo.logSyncThenSetUsersToHotSite

GO

CREATE PROCEDURE logSyncThenSetUsersToHotSite
AS
/* 
  Procedure logSyncThenSetUSersToHotsite is an elaboration of the
  failover processing established in procedure setUsersToHotSite
  Here, a final transaction log is applied at failover.
*/

EXEC logSync users, action, primary, hot_site 
EXEC setUsersToHotSite
GO