Before you Begin
Preparing to run the HCN SQL repair scripts (only if recommended by MedicalDirector Customer Care).
This procedure is valid for MedicalDirector Clinical, Pracsoft, and Bluechip. If you run Clinical / Pracsoft version 4.0 and below, and do not have SQL Server Management Studio, follow the guide for Pracsoft Installation Manager Mechanic. Otherwise, you will need to install and run SQL Server Management Studio.
Before attempting this procedure, the relevant SQL scripts are available.
The procedure assumes that the SQL server name is SERVER\HCNSQL07 . Replace this with the correct SQL server name when following these instructions, for example, ComputerName\HCNSQL07.
If you are not sure of the correct SQL Server name that the practice uses, you can find it by opening Bluechip and selecting (listed under location).
This is an advanced procedure. If you are unsure or would like assistance, contact Customer Service on 1300 300 161.
- Obtain the SQL scripts from the email attachments prior to performing the procedure.
- Steps 6 to 9 will need to be performed for each SQL repair script, unless otherwise directed.
Downloading the script attachments via webmail interfaces can damage the repair scripts. It is recommended to use a POP3 email client such as Outlook or Outlook Express to download the attachments to your computer.
If a repair script has been damaged, an error will be displayed during Step 8 (Execute SQL Script phase). If an error occurs, you will need to download the repair script again using an email client and re-run from Step 6. If the error continues to appear, you should contact MedicalDirector Customer Service to discuss other alternatives.