Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. How to uninstall Fixed Assets Management in Microsoft Dynamics GP

How to uninstall Fixed Assets Management in Microsoft Dynamics GP

View products that this article applies to.

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.

↑ Back to the top

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:
a. In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
b. In the Authentication box, click SQL Server Authentication .
c. In the User name box, type sa .
d. In the Password box, type the password for the sa user account.
e. 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:
a. In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
b. In the Authentication box, click SQL Server Authentication .
c. In the Login name box, type sa .
d. In the Password box, type the password for the sa user account.
e. 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

 

 

↑ Back to the top

Keywords: kb, kbnosurvey, kbEntireNet, kbhowto, kbMBSPartner, kbMBSMigrate, BemisKB874365

↑ Back to the top

Article Info
Article ID : 874365
Revision : 1
Created on : 3/1/2017
Published on : 3/1/2017
Exists online : False
Views : 445