How to uninstall Fixed Assets Management in Microsoft Dynamics GP

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:

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.

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:

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