User Tools

Site Tools


dynamiczip:glossary:auto_procedures

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

dynamiczip/glossary/auto_procedures.txt · Last modified: 2015/05/26 14:46 by chuck

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki