Enhancements
Enhancement#
Primary Function
Enhancement Detail
ENH-519 / ENH-520 / ENH-536
Windows 10
ENH-519
When testing the Build Master Calendar feature on a Windows 10 machine, an "Unhandled Exception Error" message occurred.
R1: An "Unhandled Exception Error" should not display when accessing the Build Master Calendar feature.
R2: If an error message is to be displayed when accessing the Build Master Calendar feature, the error message displayed should be a meaningful error message that conforms to SPIRIT’s error message standards.
R3: The Build Master Calendar feature must be compatible with Windows 10.
R4: The Build Master Calendar feature should continue to be compatible with Windows 7 machines.
CDP determined that on Windows 10 machines, the Reflection.Assembly.LoadFrom(WIC.Common.Utilities.BuildMasterCalendar).Location was not loading the assembly from the correct location. Therefore, since SPIRIT was looking for the assembly in the wrong location, there was no mastercalendar.exe in the correct path on Windows 10 machines. As a result, the SPIRIT WIC system was modified to use the correct file path. As a result, SPIRIT now retrieves the directory name of the currently-executing assembly location (participantlist.exe location) and SPIRIT now looks for the MasterCalendar.exe in the appropriate location.
|
NOTE: CDP performed thorough testing on Windows 10 operating systems. Windows 8 operating systems were not tested as part of this enhancement. |
ENH-520
When installing SPIRIT on Windows 10 machines, a "Could not find file C:\Windows\System32\Shortcuts.xml" error occurred.
R5: SPIRIT should install without error on Windows 7 (32 and 64 bit) and Windows 10 (32 and 64 bit) machines.
R6: Supporting documentation should be included in the release notes on how a State can log installation problems and show where files are being installed on the Operating System.
CDP determined that the steps to create a log file during installation were already documented in the Performing a Silent/Passive Install of the WIC Client topic of the SPIRIT WIC Detailed Functional Design Document (DFDD).
For steps to create a log file during a silent install, see step 5 of the silent install process in the Performing a Silent/Passive Install of the WIC Client topic of the SPIRIT WIC Detailed Functional Design Document (DFDD).
R7: SPIRIT should follow the correct installation path to avoid installation error.
R8: The automatic update process (from the web server) of SPIRIT on a Windows 10 machine should be considered.
R9: The upgrade to Windows 10 on Windows 7 machines that already have an existing SPIRIT installation should be considered.
CDP determined that the install.bat file referenced different Windows versions but that a reference to Windows 10 did not exist within the file. Therefore, the install.bat file was modified to reference Windows 10 and to install the software in the appropriate path on Windows 10 machines.
Additionally, the client installation file paths for the SPIRIT WIC MIS software are documented in the note below.
|
NOTE: The client installation path for the SPIRIT WIC MIS software varies based on the operating system installed on the client machine. The install.bat automatically defaults the target directory based on the operating system installed on the client machine. The file paths for operating systems supported are listed below. Installation path for Windows 10: C:\Users\Public\CSC\ Installation path for Windows 7: C:\Users\Public\CSC\ Installation path for Windows XP: C:\Documents and Settings\All Users\CSC\ Please note that the paths for Windows 7 and Windows 10 are the same (C:\Users\Public\CSC\). if a State Agency has a desire to modify the installation in any way, this is unsupported by CDP and is at their own risk |
If a State Agency has a desire to modify the installation in any way, this is unsupported and is done at the State Agency's risk.
ENH-536
Users were unable to open the Risk Factors Details Guide on Windows 10 machines.
R10: Users should not receive an error message stating that a template cannot be found.
R11: States who customize the Risk Factors Detail Guide templates should still be able to use their custom templates after a fix is implemented.
CDP determined that the paths in the initial install did not accommodate newer versions of Windows, and therefore the paths were set incorrectly when setting up the shortcuts. The paths were corrected to resolve the issues.
A timeout error message occurred when adding a food distribution item on Windows 10 machines.
R12: A timeout error message should not occur when adding a new food distribution item.
R13: A timeout error message should not occur when editing an existing food distribution item.
The SPIRIT WIC system database was modified to resolve these issues. For more information, refer to the Database Changes for this release.
The Glossary tab was blank in both the Online Help System and the Detailed Functional Design Document (DFDD) on Windows 10 machines.
R14: The Glossary tab should be available when using the Online Help System.
R15: The Glossary tab should be available when using the Detailed Functional Design Document (DFDD).
CDP determined that a 64-bit version of the HHActiveX.dll file must be installed and registered properly on 64-bit operating systems such as Windows 10. As a result, CDP created a new HHActiveXIntall.bat file to resolve the issue by installing and registering the appropriate HHActiveX.dll file on both 32-bit and 64-bit versions of Windows.
The new HHActiveXIntall.bat file is included with this release in a compressed HHActiveX Install.zip file, which needs to be extracted and run manually on machines exhibiting the blank Glossary tab.
|
This change must be done manually by the user. |
To install the HHActiveX.dll, complete the following steps:
1. Copy the HActiveX Install.zip file to the machine exhibiting the blank Glossary tab.
2. Extract the files.
3. Run the HHActiveXIntall.bat file as an administrator.
An "Unhandled Exception Error" occurred when adding race/ethnicity information on Windows 10.
R16: An "Unhandled Exception Error" should not display when clicking the Race/Ethnicity button.
R17: The Tribe drop-down list box should not be required if the American Indian or Alaskan Native check box is not checked.
CDP determined that the paths in the initial install did not accommodate newer versions of Windows, and therefore the paths were set incorrectly when setting up the shortcuts. The paths were corrected to resolve the issues.
ENH-533
Risk Factors
R1: Change current risk factor 135 - Inadequate Growth to 135Z to save historical data for infants and children categories.
To accommodate the R1 requirement for this enhancement, all currently-existing RISKFACTORID 135 rows in the RISKFACTORREFERENCE and RISKFACTOR tables were updated to change the RISKFACTORID to "135Z". For more information, see the database changes for this enhancement.
Some states may have an extra constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table. If your state currently has an FK constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table, the script below MUST be run manually on the database. Failure to run the script below in states that currently have an FK constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table will cause problems with this release of the software.
IF EXISTS (SELECT * FROM sys.foreign_keys
WHERE object_id = OBJECT_ID(N'FK_RISKFACTORREF_PRIORITYWICSTS')
AND parent_object_id = OBJECT_ID(N'RISKFACTORREFERENCE')
)
ALTER TABLE [dbo].[RISKFACTORREFERENCE]
DROP CONSTRAINT [FK_RISKFACTORREF_PRIORITYWICSTS]
IF EXISTS (SELECT * FROM sys.foreign_keys
WHERE object_id = OBJECT_ID(N'FK_RISKFACTORREF_FOODPKG')
AND parent_object_id = OBJECT_ID(N'RISKFACTORREFERENCE')
)
ALTER TABLE [dbo].[RISKFACTORREFERENCE]
DROP CONSTRAINT [FK_RISKFACTORREF_FOODPKG]
ALTER TABLE [dbo].[RISKFACTORREFERENCE]
ALTER COLUMN [ASSIGNMENTRESTRICTION] CHAR (1) NULL
For some of the USDA regulation changes to risk factors, users MUST manually update the high risk thresholds for the risk factors in the Reference Utility application module. For more information, see the Edit High Risk Threshold screen.
R2: Add a new risk factor 135 with description "Slowed/Faltering Growth Pattern" to WIC Category "Infant" only for all Breastfeeding Amounts for Age Categories "Infant 0 months to 1 month", "Infant 1 month to 3 months", and "Infant 4 months thru 5 months".
A new 135 - Slowed/Faltering Growth Pattern risk factor was added, and a new 2.29.00.asql file was created to automatically pre-populate new 135 records in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
The new 2.29.00.asql file includes different scripts that perform various updates for the 2.29.00 software release. Risk factor scripts included within the 2.29.00.asql file perform a check to determine if the state agency is Minnesota. If the current agency is MN, the risk factor scripts within the new 2.29.00.asql file do not run during the 2.29 software upgrade process.
However, not all of the required information was pre-populated for each new 135 record via the 2.29.00.asql script.
As a result, users must open each new 135 row that was created via the SQL script and complete the remaining required information for each newly-created 135 row in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
|
This change must be done manually by the user. |
To make this change in the SPIRIT WIC system, complete the following steps:
1. Open the Reference Utility application module. The Reference Utility screen displays.
2. Double-click on the Risk Factors list item in the Functions data grid. The Risk Factors screen displays.
3. Double-click on the first Risk Factor ID "135" row in the Risk Factors data grid. The Risk Factor screen displays in Edit mode.
4. Select the default food package for the risk factor in the Default Food Package ID drop-down list box.
5. Enter the default food prescription (DFP) priority for the risk factor in the DFP Priority text box.
6. Click the OK button. The Risk Factors screen displays and the Risk Factors data grid refreshes to display the updated Default Food Package ID and DFP Priority for the selected row.
7. Repeat steps 3-6 for each additional "135" row in the Risk Factors data grid.
R3: Risk factor 135 shall not be added for the Children WIC category.
To accommodate the R3 requirement for this enhancement, the code was modified so that the new risk factor 135 is not applicable to the Children WIC category.
R4: For risk factor 135, the system assignment criteria for "Infants 0 months to 1 month" (all feeding levels) shall be greater than or equal to 7% weight loss in the first two weeks of life.
To accommodate the R4 requirement for this enhancement, the code was modified to automatically assign risk factor 135 to infants in the following scenarios:
If the ASSIGNMENTMETHOD value is "S" or "B" in the RISKFACTORREFERENCE table for risk factor 135, the system will assign the risk factor according to the formula below.
System assignment criteria for "Infants 0 months to 1 month" shall be greater than or equal to (≥) 7% the infant's weight loss during the first two weeks of life. Weight loss is calculated as a decrease in weight of at least seven percent (7%) when comparing the birth weight to the current weight and when the current weight is within two (2) weeks of the date of birth. If the infant's birth weight in pounds and ounces is not available, then system assignment does not calculate for the seven percent (7%) weight loss.
R5: For risk factor 135, the weight loss for R4 shall be calculated as a decrease in weight of at least 7% when comparing the birth weight on the Health Information tab to the weight on the HT/WT/Blood tab when the weight measurement is taken within 2 weeks of the infant's date of birth.
To accommodate the R5 requirement for this enhancement, the code was modified to calculate weight loss for risk factor 135 as follows:
Infants birth to two (2) weeks of age with excessive weight loss after birth, defined as greater than or equal to (≥) seven percent (7%) of the birth weight.
R6: For risk factor 135, if the birth weight pounds and ounces is not available, then the calculation for system assignment cannot be performed for the 7% weight loss described in R5.
To accommodate the R6 requirement for this enhancement, the code was modified to check if the birth weight pounds and ounces are available. If the birth weight pounds and ounces are not available, the SPIRIT WIC system will not calculate the system assignment for a 7% loss as described in requirement R5.
R7: For risk factor 135, the system assignment criteria for infants 2 weeks to 6 months of age shall be updated to be any weight loss when comparing two separate weight measurements taken at least 8 weeks apart.
To accommodate the R7 requirement for this enhancement, the code was modified to automatically assign risk factor 135 to infants in the following scenarios:
If the ASSIGNMENTMETHOD value is "S" or "B" in the RISKFACTORREFERENCE table for risk factor 135, the system will assign the risk factor according to the formula below.
If an infant is between two (2) weeks to six (6) months of age, weight loss is calculated when comparing two separate weight measurements taken at least eight (8) weeks apart. In some cases, if there is no prior measurement to compare, then the infant's birth information is used as the prior weight for calculation. However, the birth measurement also should be at least eight (8) weeks prior to the current measurement. If any weight loss has occurred, then the risk factor is assigned.
R8: Risk factor 135's priority level shall remain priority 1 for applicable Infant categories.
To accommodate the R8 requirement for this enhancement, the priority for the new risk factor 135 is "1".
R9: Risk factor 135, should still be CPA only or both for the assignment method.
To accommodate the R9 requirement for this enhancement, the assignment method and assignment restriction for the new risk factor 135 were carried over from the old risk factor 135.
R10: Add a new 352A risk factor with "Infectious Diseases - Acute" as the description to all WIC Categories, all Age Categories, and all Breastfeeding levels. The assignment method for all rows is "C".
To accommodate the R10 requirement for this enhancement, all currently-existing RISKFACTORID 352 rows in the RISKFACTORREFERENCE and RISKFACTOR tables were updated to change the RISKFACTORID to "352Z" and the existing risk factor 352 was deactivated within the SPIRIT WIC system. For more information, see the database changes for this enhancement.
A new 352A - Infectious Diseases - Acute risk factor was added, and a new 2.29.00.asql file was created to automatically pre-populate new 352A records in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
The new 2.29.00.asql file includes different scripts that perform various updates for the 2.29.00 software release. Risk factor scripts included within the 2.29.00.asql file perform a check to determine if the state agency is Minnesota. If the current agency is MN, the risk factor scripts within the new 2.29.00.asql file do not run during the 2.29 software upgrade process.
However, not all of the required information was pre-populated for each new 352A record via the 2.29.00.asql script.
As a result, users must open each new 352A row that was created via the SQL script and complete the remaining required information for each newly-created 352A row in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
|
This change must be done manually by the user. |
To make this change in the SPIRIT WIC system, complete the following steps:
1. Open the Reference Utility application module. The Reference Utility screen displays.
2. Double-click on the Risk Factors list item in the Functions data grid. The Risk Factors screen displays.
3. Double-click on the first Risk Factor ID "352A" row in the Risk Factors data grid. The Risk Factor screen displays in Edit mode.
4. Select the default food package for the risk factor in the Default Food Package ID drop-down list box.
5. Enter the default food prescription (DFP) priority for the risk factor in the DFP Priority text box.
6. Click the OK button. The Risk Factors screen displays and the Risk Factors data grid refreshes to display the updated Default Food Package ID and DFP Priority for the selected row.
7. Repeat steps 3-6 for each additional "352A" row in the Risk Factors data grid.
R11: Add a new 352B risk factor with "Infectious Diseases - Chronic" as the description for all WIC Categories, all Age Categories, and all Breastfeeding levels. The assignment method for all rows is "C".
To accommodate the R11 requirement for this enhancement, all currently-existing RISKFACTORID 352 rows in the RISKFACTORREFERENCE and RISKFACTOR tables were updated to change the RISKFACTORID to "352Z" and the existing risk factor 352 was deactivated within the SPIRIT WIC system. For more information, see the database changes for this enhancement.
A new 352B - Infectious Diseases - Chronic risk factor was added, and a new 2.29.00.asql file was created to automatically pre-populate new 352B records for in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
The new 2.29.00.asql file includes different scripts that perform various updates for the 2.29.00 software release. Risk factor scripts included within the 2.29.00.asql file perform a check to determine if the state agency is Minnesota. If the current agency is MN, the risk factor scripts within the new 2.29.00.asql file do not run during the 2.29 software upgrade process.
However, not all of the required information was pre-populated for each new 352B record via the 2.29.00.asql script.
As a result, users must open each new 352B row that was created via the SQL script and complete the remaining required information for each newly-created 352B row in the Risk Factors data grid on the Risk Factor screen in the Reference Utility application module.
|
This change must be done manually by the user. |
To make this change in the SPIRIT WIC system, complete the following steps:
1. Open the Reference Utility application module. The Reference Utility screen displays.
2. Double-click on the Risk Factors list item in the Functions data grid. The Risk Factors screen displays.
3. Double-click on the first Risk Factor ID "352B" row in the Risk Factors data grid. The Risk Factor screen displays in Edit mode.
4. Select the default food package for the risk factor in the Default Food Package ID drop-down list box.
5. Enter the default food prescription (DFP) priority for the risk factor in the DFP Priority text box.
6. Click the OK button. The Risk Factors screen displays and the Risk Factors data grid refreshes to display the updated Default Food Package ID and DFP Priority for the selected row.
7. Repeat steps 3-6 for each additional "352B" row in the Risk Factors data grid.
R12: DFDD - Risk Factors Matrix: update risk factor 135's title to "Slowed/Faltering Growth Pattern".
To accommodate the R12 requirement for this enhancement, risk factor 135 was updated in the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R13: DFDD - Risk Factors Matrix: change risk factor 135's Definition column for children to "N/A".
To accommodate the R13 requirement for this enhancement, risk factor 135 was updated in the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R14: DFDD - Risk Factors Matrix: change risk factor 135's Definition column for infants to only the two bullet points below:
Infants birth to two (2) weeks of age with excessive weight loss after birth, defined as greater than or equal to (≥) seven percent (7%) of the birth weight.
Infants two (2) weeks to six (6) months of age with any weight loss. Use two (2) separate weight measurements taken at least eight (8) weeks apart.
To accommodate the R14 requirement for this enhancement, risk factor 135 was updated in the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R15: DFDD - Risk Factors Matrix: remove the existing risk factor 352 - Infectious Disease and add the following two new risk factors:
352A Infectious Diseases - Acute
352B Infectious Diseases - Chronic
To accommodate the R15 requirement for this enhancement, risk factor 352 was removed from the Risk Factors Matrix and two new risk factors, 352A and 352B, were added to the Risk Factors Matrix. For more information, see the DFDD changes for this enhancement.
R16: DFDD - Risk Factors Matrix: add a new 352A risk factor as follows:
352A:
The table for 352A should include the same headers as all other risk factors.
Categories shall be Pregnant, Breastfeeding, Non-breastfeeding, Children, and Infants.
Assignment shall be "CPA Assigned Only" for all categories.
Priorities shall be P = 1, B = 1, N < 18 yrs = 3, N ≥ 18 yrs = 6, C=3, and I=1
The Definition column shall be the same for all categories. The Definition column shall be as follows:
A disease which is characterized by a single or repeated episode of relatively rapid onset and short duration. Infectious diseases come from bacteria, viruses, parasites, or fungi and spread directly or indirectly from person to person (1). Infectious diseases may also be zoonotic, which are transmitted from animals to humans, or vector-borne, which are transmitted from mosquitoes, ticks, and fleas to humans (1, 2). These diseases and/or conditions include, but are not limited to (an extensive listing of infectious diseases can be found at http://www.nlm.nih.gov/medlineplus/infections.html):
Bronchitis (3 episodes in last 6 months)
Hepatitis A
Hepatitis E
Listeriosis
Meningitis
Parasitic
Pneumonia
The infectious disease must be present within the past six months, and diagnosed, documented, or reported by a physician or someone working under a physician’s orders, or as self-reported by applicant/participant/caregiver.
To accommodate the R16 requirement for this enhancement, risk factor 352A was added to the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R17: DFDD - Risk Factors Matrix: add a new 352B risk factor as follows:
352B:
The table for 352B should include the same headers as all other risk factors.
Categories shall be Pregnant, Breastfeeding, Non-breastfeeding, Children, and Infants.
Assignment shall be "CPA Assigned Only" for all categories.
Priorities shall be P = 1, B = 1, N < 18 yrs = 3, N ≥ 18 yrs = 6, C=3, and I=1
The Definition column shall be the same for all categories. The Definition column shall be as follows:
Conditions likely lasting a lifetime and require long-term management of symptoms. Infectious diseases come from bacteria, viruses, parasites, or fungi and spread directly or indirectly, from person to person (1). Infectious diseases may also be zoonotic, which are transmitted from animals to humans, or vector-borne, which are transmitted from mosquitoes, ticks, and fleas to humans (1, 2). These diseases and/or conditions include, but are not limited to (an extensive listing of infectious diseases can be found at http://www.nlm.nih.gov/medlineplus/infections.html):
Acquired Immunodeficiency Syndrome (AIDS)
Hepatitis B
Hepatitis C
Hepatitis D
Human Immunodeficiency Virus (HIV)
Presence of condition diagnosed, documented, or reported by a physician or someone working under a physician’s orders, or as self-reported by applicant/participant/caregiver.
To accommodate the R17 requirement for this enhancement, risk factor 352B was added to the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R18: DFDD - Risk Factors Matrix: update risk factor 411's Definition column to the following for the respective sub risks:
411.3:
Examples of inappropriate complementary foods:
Adding sweet agents such as sugar, honey, or syrups to any beverage (including water) or prepared food, or used on a pacifier
AND
Introducing any food other than human milk or iron-fortified infant formula before 6 months of age.
411.7:
Examples of inappropriate frequency of nursing:
Scheduled feedings instead of demand feedings
AND
Less than 8 feedings in 24 hours if less than 2 months of age.
411.9:
Limited or no access to a:
Safe water supply (documented by appropriate officials e.g., municipal or health department authorities)
Heat source for sterilization
AND/OR
Refrigerator or freezer for storage.
Failure to prepare, handle, and store bottles, storage containers or breast pumps properly; examples include:
Human Milk
Thawing/heating in a microwave
Refreezing
Adding freshly expressed unrefrigerated human milk to frozen human milk
Adding freshly pumped chilled human milk to frozen human milk in an amount that is greater than the amount of frozen human milk
Feeding thawed refrigerated human milk more than 24 hours after it was thawed
Saving human milk from a used bottled for another feeding
Failure to clean breast pump per manufacturer’s instruction
Donor human milk acquired directly from individuals or the Internet
Formula
Failure to prepare and/or store formula per manufacturer’s or physician instructions
Storing at room temperature for more than 1 hour
Using formula in a bottle one hour after the start of a feeding
Saving formula from a used bottle for another feeding
Failure to clean baby bottle properly
To accommodate the R18 requirement for this enhancement, risk factor 411 was updated in the Risk Factors Matrix based on the documentation above. For more information, see the DFDD changes for this enhancement.
R19: Release Note Reminder: States will need to update the risk factor detail guide spreadsheet templates that are invoked when the Risk Factors Detail Guide button is clicked.
To accommodate the R19 requirement for this enhancement, refer to the detailed instructions below.
Users MUST manually update the risk factor details guide spreadsheet templates for the new risk factor changes in the {drive letter}:\Users\Public\CSC\WIC\TemplatesBase\ and then copy the updated files from the TemplatesBase\ folder to the Templates\ folder.
For Client installations, complete the following steps:
1. Open Windows Explorer.
2. Navigate to the {drive letter}:\Users\Public\CSC\WIC\TemplatesBase\ folder.
3. Open each risk factor detail guide spreadsheet and modify the risk factors as necessary. Depending on your state, the following risk factor detail guide spreadsheets may be available within the TemplatesBase\ folder:
RiskFactorGuide.xls
RiskFactorGuide_BF.xls
RiskFactorGuide_Child.xls
RiskFactorGuide_Infant.xls
RiskFactorGuide_NBF.xls
RiskFactorGuide_Pregnant.xls
4. Copy the updated risk factor detail guide spreadsheet files (select the files and Ctrl+C) and paste the copied files (Ctrl+V) into the {drive letter}:\Users\Public\CSC\WIC\Templates\ folder. Overwrite the existing files as necessary.
5. Navigate to the {drive letter}:\Users\Public\CSC\WIC\Templates\ folder.
6. Paste the copied file(s) into the folder (Ctrl+V).
R20: The States would like an SQL Script to export all of the Risk Factors that will create an insert SQL Script for implementation in production.
To accommodate the R20 requirement for this enhancement, a new RF135_352_pull_off_script.sql file was created that copies risk factors 135Z, 135, 352Z, 352A, and 352B from UAT to Production environments. For more information, see the database changes for this enhancement.
The RF135_352_pull_off_script.sql file must be run manually by the user. 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.
