INTRODUCTION
This article describes how to re-create stored procedures for a company database and for the DYNAMICS database for Manufacturing in Microsoft Dynamics GP.
More Information
Microsoft Dynamics GP 9.0
How to re-create stored procedures for a company database and for the DYNAMICS database
-
Make sure that all users are logged off Microsoft Dynamics GP.
-
Back up the DYNAMICS database and all the company databases.
-
Use one of the following methods to start a query tool:
-
If you are running Microsoft SQL Server 2000, click Start, point to All Programs, click Microsoft SQL Server, and then click Query Analyzer.
-
If you are running Microsoft SQL Server 2005, click Start, point to All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
-
Click File, and then click Open. Open the Procs.cmp file. The following folder is the default folder for the Procs.cmp file:
C:\Program Files\Microsoft Dynamics\GP \SQL\Install\346\Company
-
Click Edit, and then click Replace.
-
In the Find what box, type %SysDBName%.
-
In the Replace with box, type DYNAMICS, and then click Replace All.
-
Run the script for each company database. To do this, click the green arrow button. Or, press F5.
-
Click File, and then click Open. Open the Dexprocs.cmp file. The following folder is the default folder for the Dexprocs.cmp file:
C:\Program Files\Microsoft Dynamics\GP \SQL\Install\346\Company
-
Run the script for each company database. To do this, click the green arrow button. Or, press F5.
-
In the Database list, click DYNAMICS.
-
Click File, and then click Open. Open the Procs.sys file. The following folder is the default folder for the Procs.cmp file:
C:\Program Files\Microsoft Dynamics\GP \SQL\Install\346\System
-
Run the script. To do this, click the green arrow button. Or, press F5.
-
Click File, and then click Open. Open the Procs.sys file. The following folder is the default folder for the Dexprocs.sys file:
C:\Program Files\Microsoft Dynamics\GP \SQL\Install\346\System
-
Run the script. To do this, click the green arrow button. Or, press F5.
Versions that are earlier than Microsoft Dynamics GP 9.0
How to re-create stored procedures for a company database and for the DYNAMICS database
-
Make sure that all users are logged off Microsoft Business Solutions - Great Plains.
-
Back up the DYNAMICS database and all the company databases.
-
Use one of the following methods to start a query tool:
-
If you are running SQL Server 2000, click Start, point to All Programs, click Microsoft SQL Server, and then click Query Analyzer.
-
If you are running SQL Server 2005, click Start, point to All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
-
In the Database list, click the company database for which you want to re-create the stored procedure.
-
Click File, and then click Open.
-
In the Open Query File window, click Mfgprocs.cmp. The following folder is the default folder for the Mfgprocs.cmp file:
C:\Program Files\Microsoft Business Solutions\Great Plains\Sql\Company
-
Run the script for each company database. To do this, click the green arrow button. Or, press F5.
-
Click File, and then click Open.
-
In the Open Query File window, click Mfgdprocs.cmp. The following folder is the default folder for the Mfgdprocs.cmp file:
C:\Program Files\Microsoft Business Solutions\Great Plains\Sql\Company
-
Run the script for each company database. To do this, click the green arrow button. Or, press F5.
-
In the Database list, click DYNAMICS.
-
Click File, and then click Open.
-
In the Open Query File window, click Mfgprocs.sys. The following folder is the default folder for the Mfgprocs.sys file:
C:\Program Files\Microsoft Business Solutions\Great Plains\Sql\System
-
Run the script. To do this, click the green arrow button. Or, press F5.
-
Click File, and then click Open.
-
In the Open Query File window, click Mfgprocs.sys. The following folder is the default folder for the Mfgprocs.sys file:
C:\Program Files\Microsoft Business Solutions|Great Plains\Sql\System
-
Run the script. To do this, click the green arrow button. Or, press F5.
-
Click File, and then click Open.
-
In the Open Query File window, click Mfgdproc.sys. The following folder is the default folder for the Mfgdproc.sys file:
C:\Program Files\Microsoft Business Solutions|Great Plains\Sql\System
-
Run the script. To do this, click the green arrow button. Or, press F5.
-
In Microsoft Great Plains Utilities, perform the Perform Special Upgrade task. To do this, follow these steps:
-
Start Microsoft Business Solutions - Great Plains Utilities.
-
In the Welcome to Microsoft Business Solutions - Great Plains Utilities window, verify the server name, type the system administrator user ID and password, and then click OK.
Note You must log on to Microsoft Business Solutions - Great Plains Utilities as the system administrator user. -
Click Next two times.
-
In the Additional Tasks window, click Perform special upgrade in the task list. A check mark will appear next to the Dynamics (System) database and next to all the company databases to indicate a successful upgrade.
-