Interpret SQL file

Listed below are the contents of this SQL file:

/lib/TOOLS/AM/sql/sp_ApplyStandByLog.sql

To evaluate the contents of the file, select a database pool and press the Post SQL button. If the database pool you select connects to an Illustra database and error is encountered, the database will be rolled back to its state just before the server began processing the file.

Warning: The window below contains only the first 50 lines of this file. You may want to download the entire file and examine it locally before loading it into your database.

-- Be sure to create this in the master database

if exists (SELECT * from sysobjects where id = object_id('dbo.sp_ApplyStandByLog') and sysstat & 0xf = 4)
	drop procedure dbo.sp_ApplyStandByLog
GO

CREATE PROCEDURE sp_ApplyStandByLog
  @DBName sysname,
  @BackupFileName nvarchar(256),
  @UndoFile nvarchar(256),
  @MoveFileTo nvarchar(256) = NULL,
  @RestoreWithRecovery bit = 0
AS
  -- From SQL Server Resource Kit Simple Log Shipping
  -- Modified for longer path to log backup file,
  -- forcing single-user mode prior to applying
  -- and putting back into multi-user when done, and
  -- optionally moving the restored file into specified directory
  -- Also if @RestoreWithRecovery = 1, takes database OUT of Standby mode
  -- if the log was successfully applied

DECLARE @RestoreCmd 	nvarchar(1024)
  DECLARE @ErrDesc 	nvarchar(1024)
  DECLARE @command	nvarchar(1024)

SET @RestoreCmd = 
    'RESTORE LOG ' + @DBName 
    + ' FROM DISK=''' + @BackupFileName 
    + ''' WITH STANDBY=''' + @UndoFile
  PRINT 'Executing ' + @RestoreCmd

-- Force disconnection of all users and put db in single-user mode:
  SELECT @command = N'ALTER DATABASE [' + @DBName + N'] SET SINGLE_USER WITH ROLLBACK IMMEDIATE'
  EXECUTE sp_executesql @command

RESTORE LOG @DBName FROM DISK=@BackupFileName WITH STANDBY=@UndoFile

IF @@ERROR <> 0
    BEGIN
      SET @ErrDesc = 
      'sp_ApplyStandByLog Error ' + convert(varchar(9),@@Error) + ' occurred on ' 
      + 'database %s restoring backup file %s'
      RAISERROR (@ErrDesc,19,1,@DBName, @BackupFileName) 
    END
  ELSE
    BEGIN
      IF @MoveFileTo IS NOT NULL
        BEGIN
          DECLARE @cmd nvarchar(1024)
          SET @cmd = 'move "'+@BackupFileName+'" '+@MoveFileTo+'"'

AOLserver/4.5.2 on https://am.net