Welcome Guest, you are in: <root>iCISPTC • Login

Page History: Client Database Utility Scripts

Compare Page Revisions

10 9 8 7 6 5 4 3 2 1 0 Current 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 12/07/2013 10:25

Client Database Utility Scripts and Procedures¶

1. Backup and restore customer security settings
   1. When to use this script
      • Use this script to backup customer security settings before rebuilding the security setup data for the version of iCIS being used.
   2. How to use this script
      • For this script to work in SQL Server Management Studio the default max number of characters to display for each column must be increased. You need bring up the options dialog using the tools menu (Tools->Options…)
        • Expand “Query Results”
        • Expand “SQL Server”
        • Select “Results to text” (that refers to the highlighted button in the image below. You need to have it selected as shown too)
        • Change max characters… from 256 or whatever it is to something big like 2000
          
          

When you’re ready to save off the permissions run the script and save the text in the results window to a script file.
When you’re ready to restore the permissions run that script file.