script_row_level_locks

Execution of the script via run_script_remote will produce a recovery script to reestablish row level locking on all tables with the option enabled at the time the script is run.

DELETE scripts
WHERE name = 'script_row_level_locks'
GO
INSERT scripts 
VALUES('script_row_level_locks','DECLARE @rowid INT,')
INSERT scripts 
VALUES('script_row_level_locks','        @CMD VARCHAR(255)')
INSERT scripts 
VALUES('script_row_level_locks','SET NOCOUNT ON')
INSERT scripts 
VALUES('script_row_level_locks','SELECT @CMD = "PRINT " + CHAR(39) +')
INSERT scripts 
VALUES('script_row_level_locks','    "Enable row level locking on identified tables in " +') 
INSERT scripts 
VALUES('script_row_level_locks','    DB_NAME() + CHAR(39)')
INSERT scripts 
VALUES('script_row_level_locks','PRINT @CMD')
INSERT scripts 
VALUES('script_row_level_locks','SELECT @rowid = (SELECT MIN(id) FROM sysobjects')
INSERT scripts 
VALUES('script_row_level_locks','                 WHERE userstat & 0xf = 1')
INSERT scripts 
VALUES('script_row_level_locks','                 AND sysstat & 0xf = 3)')
INSERT scripts 
VALUES('script_row_level_locks','WHILE @rowid IS NOT NULL')
INSERT scripts 
VALUES('script_row_level_locks','  BEGIN')
INSERT scripts 
VALUES('script_row_level_locks','    SELECT @CMD = "PRINT " + CHAR(39) +') 
INSERT scripts 
VALUES('script_row_level_locks','                  OBJECT_NAME(@rowid) + CHAR(39)')
INSERT scripts 
VALUES('script_row_level_locks','    PRINT @CMD')
INSERT scripts 
VALUES('script_row_level_locks','    SELECT @CMD = "EXEC sp_tableoption " + CHAR(39) +') 
INSERT scripts 
VALUES('script_row_level_locks','                  OBJECT_NAME(@rowid) + CHAR(39) + "," +')
INSERT scripts 
VALUES('script_row_level_locks','                  CHAR(39) + "insert row lock" + CHAR(39) +') 
INSERT scripts 
VALUES('script_row_level_locks','                  "," + CHAR(39) + "true" + CHAR(39)')
INSERT scripts 
VALUES('script_row_level_locks','    PRINT @CMD')
INSERT scripts 
VALUES('script_row_level_locks','    SELECT @rowid = (SELECT MIN(id) FROM sysobjects')
INSERT scripts 
VALUES('script_row_level_locks','                     WHERE userstat & 0xf = 1')
INSERT scripts 
VALUES('script_row_level_locks','                     AND sysstat & 0xf = 3')
INSERT scripts 
VALUES('script_row_level_locks','                     AND id > @rowid)')
INSERT scripts 
VALUES('script_row_level_locks','  END')