KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Auto Procedure ======
Microsoft Dynamics GP auto generates stored procedures when it creates SQL tables. These stored procedures are used to provide performance enhancements when fetching records from these tables. These procedures (typically referred to as Auto Procedures) can be viewed from within SQL Server Management Studio by selecting the database and then selecting Programmability >> Stored Procedures and then browsing for the set of Auto Procedures related to the table in question. The name of the Auto Procedures will start with zDP_ followed by the table name such as DZ00700 followed by a few additional letters. An example would be zDP_DZ00700F_1.

Each table will have a set of these Auto Procedures the number of which is dependent on how many indexes or keys there are on the table.

----

[[Glossary]]