-
Pre-requisite: 1. If there is no SQL server management studio installed, you will need to install the Microsoft SQL CMD utility to connect to the database 2. Database login information 3. SQL command that will be used 4. SQLCMD options that will be used Setup for (1): 1. Install the SQL native client...
-
Certify requires nightly maintenance to ensure optimum application performance. Your support person can give you the files needed for this. There are two SQL scripts for which nightly jobs should be created: UpdateStatistics.sql ShrinkDB.sql These scripts should be executed nightly in the order listed...