How to uninstall Fixed Assets Management in Microsoft Dynamics GP

Article ID: 874365 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

This article describes how to use Microsoft SQL Server scripts to uninstall Fixed Asset Management in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains 8.0.

MORE INFORMATION

To use SQL Server scripts to uninstall Fixed Asset Management, follow the appropriate method.

Method 1: Microsoft SQL Server 2008 and Microsoft SQL Server 2005

  1. Download the KB874365_2005.zip file. The following file is available for download from the Microsoft Dynamics File Exchange Server:

    KB874365_2005.zip
    Release Date: February 23, 2009

    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

    Note You need a Windows Live ID account to download this file.
  2. Extract the contents of the file to a folder on the hard disk.
  3. Start SQL Server Management Studio.
  4. Connect to the server that hosts the Microsoft Dynamics GP databases. To do this, follow these steps:
    1. In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
    2. In the Authentication box, click SQL Server Authentication.
    3. In the User name box, type sa.
    4. In the Password box, type the password for the sa user account.
    5. Click Connect.
  5. On the File menu, point to New, and then click Query with Current Connection.
  6. Use a copy-and-paste operation to copy the contents of the "Drop Company Procs SQL2005.txt" file into the query window.
  7. Run the query that you created in step 6 to remove the Fixed Asset Management stored procedures in the company database.

    Note Before you run the query, change the script to use the name of the database where the stored procedures are located. The name of the database is the name of the company.
  8. Use a copy-and-paste operation to copy the contents of the "Drop Company Tables SQL2005.txt" file into the query window.
  9. Run the query that you created in step 8 to remove the Fixed Management Asset tables in the company database.

    Note Before you run the query, change the script to use the name of the database where the tables are located. The name of the database is the name of the company.
  10. Use a copy-and-paste operation to copy the contents of the "Drop Dynamics Procs SQL2005.txt" file into the query window.
  11. Run the query that you created in step 10.
  12. Use a copy-and-paste operation to copy the contents of the "Drop Dynamics tables SQL2005.txt" file into the query window.
  13. Run the query that you created in step 12.
  14. Start Windows Explorer.
  15. In Microsoft Dynamics GP, open the Microsoft\GP folder.

    In Microsoft Business Solutions - Great Plains 8.0, open the "Microsoft Business Solutions\Great Plains" folder.
  16. Right-click each file that begins with "FA," and then click Delete.
  17. Right-click R309.dic, and then click Delete.

    Note The path of the R309.dic file is listed in the Dynamics.set file. By default, the Dynamics.set file is located in the Microsoft\GP folder or in the "Microsoft Business Solutions\Great Plains" folder.
  18. Right-click F309.dic, and then click Delete.

    Note The path of the F309.dic file is listed in the Dynamics.set file. By default, the Dynamics.set file is located in the Microsoft\GP folder or in the "Microsoft Business Solutions\Great Plains" folder.

Method 2: Microsoft SQL Server 2000

  1. Download the KB874365_2000.zip file. The following file is available for download from the Microsoft Dynamics File Exchange Server:

    KB874365_2000.zip
    Release Date: February 23, 2009

    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

    Note You need a Windows Live ID account to download this file.
  2. Extract the contents of the file to a folder on the hard disk.
  3. Start Query Analyzer.
  4. Connect to the server that hosts the Microsoft Dynamics GP databases. To do this, follow these steps:
    1. In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
    2. In the Authentication box, click SQL Server Authentication.
    3. In the Login name box, type sa.
    4. In the Password box, type the password for the sa user account.
    5. Click OK.
  5. Use a copy-and-paste operation to copy the contents of the "Drop Company Procs SQL2000.txt" file into the query window.
  6. Run the query that you created in step 5 to remove the Fixed Asset Management stored procedures in the company database.

    Note Before you run the query, change the script to use the name of the database where the stored procedures are located. The name of the database is the name of the company.
  7. Use a copy-and-paste operation to copy the contents of the "Drop Company Tables SQL2000.txt" file into the query window.
  8. Run the query that you created in step 7 to remove the Fixed Management Asset tables in the company database.

    Note Before you run the query, change the script to use the name of the database where the tables are located. The name of the database is the name of the company.
  9. Use a copy-and-paste operation to copy the contents of the "Drop Dynamics Procs SQL2000.txt" file into the query window.
  10. Run the query that you created in step 9.
  11. Use a copy-and-paste operation to copy the contents of the "Drop Dynamics tables SQL2000.txt" file into the query window.
  12. Run the query that you created in step 11.
  13. Start Windows Explorer.
  14. In Microsoft Dynamics GP, open the Microsoft\GP folder.

    In Microsoft Business Solutions - Great Plains 8.0, open the "Microsoft Business Solutions\Great Plains" folder.
  15. Right-click each file that begins with "FA," and then click Delete.
  16. Right-click R309.dic, and then click Delete.

    Note The path of the R309.dic file is listed in the Dynamics.set file. By default, the Dynamics.set file is located in the Microsoft\GP folder or in the "Microsoft Business Solutions\Great Plains" folder.
  17. Right-click F309.dic, and then click Delete.

    Note The path of the F309.dic file is listed in the Dynamics.set file. By default, the Dynamics.set file is located in the Microsoft\GP folder or in the "Microsoft Business Solutions\Great Plains" folder.

Properties

Article ID: 874365 - Last Review: July 25, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
Keywords: 
kbsurveynew kbexpertisebeginner kbhowto kbexpertiseinter kbmbsmigrate KB874365

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com