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 Programibility » 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