User Tools

Site Tools


dynamiczip:glossary:auto_procedures

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dynamiczip:glossary:auto_procedures [2015/04/28 23:14]
127.0.0.1 external edit
dynamiczip:glossary:auto_procedures [2015/05/26 14:46] (current)
chuck
Line 1: Line 1:
 ====== Auto Procedure ====== ====== 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 ​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.+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. 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.
dynamiczip/glossary/auto_procedures.txt ยท Last modified: 2015/05/26 14:46 by chuck