Procedure List

Run the HCN SQL repair scripts (only if recommended by MedicalDirector Customer Care).

Before you begin

Ensure MedicalDirector applications have been closed on all machines before you begin this procedure.

Procedure

  1. Create a full backup including documents.
  2. Save the script email attachments to a location on your hard drive.
Start the SQL Server Management Studio:
  1. From the Windows Start menu, select All Programs.
  2. From the All Programs window, locate Microsoft SQL Server; click the SQL Server Management Studio.
When SQL Server Management Studio is open:
  1. In the Connect to Server window, check the following is correct then click Connect.
    • Server Type: Database Engine.
    • Server name: Server Name/HCNSQL07 (as shown in the location in Bluechip Help > About).
    • Authentication: Windows Authentication
  2. In the Object Explorer screen, browse to the location on the local hard drive of the saved script in Step 2.
  3. Double-click the script file ID0000 – Script Name. You will now be presented with the SQL Server Management Studio window.
  4. In the dropdown box next to the Exclamation button (!), select the Bluechip or HCN database relevant to the program you received the script for.
  5. Click Execute.
After the script has been run successfully, save the logs.
  1. Click in the Results (Messages) pane.
  2. Click File > Save Results As.
  3. In the Save Results window, browse to the location on the local hard drive where you would like to save the results.
  4. Save with the filename of Script Today's Date, for example, Script 14042012.
  5. Click Save.
Clean up and test
  1. Close all programs back to the Desktop.
  2. Delete the script from the computer that was saved in step 2. This script should never be run again without recommendation by Customer Service.
  3. Start Bluechip.and open the module that experienced the problems.
  4. Test whether the problem has been fixed and the data is correct.
    • If you are satisfied the data is correct, create another full backup and continue using Bluechip.
    • If you are NOT satisfied, restore the backup created in Step 1 and contact MedicalDirector Customer Service.

Results

The problem is fixed.