2.32.01 Database Changes

Contents ShowHide

Changes made to the SPIRIT WIC database in this release of the software are detailed below.

The RF142_311_383_pull_off_script.sql file must be run manually by the user, and the user who runs the script must have SQL object create permissions on the server. Before running the script, ensure the SSMS environment is set up (SSMS needs to be set up to create the script). CDP also recommends a backup of the RISKFACTORREFERENCE table before running the script, and any modifications to the generated script are done at the State Agency's own risk.

Complete the following steps to create the script (by creating a file):

1.        Open SSMS.

2.        Go to Tools.

3.        Go to Options.

4.        Go to Query results.

5.        In the Default destination for results, change to results to file.

6.        Go to Results to Text and change Maximum number of characters displayed in each column to 8192.

Complete the following steps to execute the script:

1.        Open the pull off script in SSMS.

2.        Run the script.

3.        Save as an .sql file.

Complete the following steps to run the results script on Production:

1.        Open SSMS.

2.        Run the results script.

OUT OF MEMORY ERRORS

If an out of memory error occurs due to a large amount of data being processed, execute the following steps using a 64-bit sqlcmd prompt:

1.        Open a command prompt in this location (drive letter may be different).

{drive letter}:\Program Files\Microsoft SQL Server\100\Tools\Binn

2.        Run the following command:

sqlcmd -S .\ -d databasename -U username -P userpassword -i script location/name.sql

Ex. sqlcmd -S .\ -d MODevDatabase -U jsmith -P admin1234 -i C:\UATpulloff.sql

3.        Save as an .sql file.