Copy security Settings for RMS Store Ops 2.0 to other stores:

Hi Jimmy,

Try this:

1º set up a model RMS SO database, based on your stores and apply the Security Configuration yuou wish to have. 2º Connect to the database, with RMS SO Administrator and exec this query: "SELECT 'INSERT INTO [Security] ([FormName],[ClassName],[ControlType],[ControlName],[ControlIndex], [ReadDisableCode],[ChangeDisableCode],[ColumnTitle]) values ('+''''+FormName+''''+','+''''+ClassName+''''+','+''''+ControlType+''''+',' +''''+ControlName+''''+','+''''+rtrim(cast(ControlIndex as char))+''''+',' +''''+rtrim(cast(ReadDisableCode as char))+''''+','+''''+rtrim(cast(ChangeDisableCode as char)) +''''+','+''''+ColumnTitle+''''+')' FROM Security" (this will give You all the INSERT's that You will need for the rest of the stores) 3º Go back to your RMS HQ Manager, and after doing all the Backup's needed, for all the RMS databases HQ and the stores, create a new Worksheet, type 51, containing all the INSERT's (results from 2º) into the Worksheet lines Please remeber that, Worksheet 51 has a limitation of string lenght (think 256 char) per line, so You may need to make few Worksheets or more lines in the same worksheet.

Please make backups on all the databases before You try this.

Best regards, A.