dynamiczip:faq:recreate_dynamiczip_stored_procedures_faq
Differences
This shows you the differences between two versions of the page.
| dynamiczip:faq:recreate_dynamiczip_stored_procedures_faq [2015/04/17 22:31] – external edit 127.0.0.1 | dynamiczip:faq:recreate_dynamiczip_stored_procedures_faq [2017/09/08 16:52] (current) – conni | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| This procedure is rarely used. The DynamicZip stored procedures are created as part of the DynamicZip create tables procedure. These are the stored procedures automatically generated by Dexterity for SQL table access. Under normal circumstances these stored procedures are permanent and do not change for the life of the table to which they pertain. | This procedure is rarely used. The DynamicZip stored procedures are created as part of the DynamicZip create tables procedure. These are the stored procedures automatically generated by Dexterity for SQL table access. Under normal circumstances these stored procedures are permanent and do not change for the life of the table to which they pertain. | ||
| - | Situations where you would use this procedure include version changes by Microsoft Dynamics GP (Great Plains) | + | Situations where you would use this procedure include version changes by Microsoft Dynamics GP in which they have modified the auto generated stored procedures. After installing the new version, Dexterity will expect those modified stored procedures to exist for each table. After recreating the DynamicZip stored procedures in this situation, DynamicZip will be in sync with Dexterity. Another situation could be a migration of your data from one version of Microsoft SQL Server to another. |
| **To recreate stored procedures: | **To recreate stored procedures: | ||
dynamiczip/faq/recreate_dynamiczip_stored_procedures_faq.txt · Last modified: 2017/09/08 16:52 by conni