User Tools

Site Tools


dynamiczip:glossary:drop_recreate_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
dynamiczip:glossary:drop_recreate_table [2015/05/26 14:54]
chuck
dynamiczip:glossary:drop_recreate_table [2017/09/11 20:59] (current)
conni
Line 3: Line 3:
 When you use the [[dynamiczip:​windows:​DZ Table Maintenance window]] to Drop & Recreate a DynamicZip table, the existing table and related [[dynamiczip:​glossary:​auto_procedures|stored procedures]] will all be deleted. A new copy of the tables and stored procedures will then be created. All records in the old table will be lost. The new table will contain no records. When you use the [[dynamiczip:​windows:​DZ Table Maintenance window]] to Drop & Recreate a DynamicZip table, the existing table and related [[dynamiczip:​glossary:​auto_procedures|stored procedures]] will all be deleted. A new copy of the tables and stored procedures will then be created. All records in the old table will be lost. The new table will contain no records.
  
-If you are unable to use the [[dynamiczip:​windows:​DZ Table Maintenance window]] to Drop & Recreate a DynamicZip table, you can drop (delete) the table using the SQL Server Management Studio. When you delete the table in SQL Server Management Studio, you will need to delete the related ​[[dynamiczip:​glossary:​auto_procedures|stored procedures]] also. If any of the related ​[[dynamiczip:​glossary:​auto_procedures|stored procedures]] still exist from the deleted table, DynamicZip will not be able to recreate the table. After deleting the table and its related stored procedures, log back into Microsoft Dynamics GP as sa or DYNSA. Open the [[dynamiczip:​windows:​DZ Table Status window]]. The table may have been automatically recreated if so, it will appear in the scrolling window with a status of successful. If not select **Create SQL Tables** from the DynamicZip menu.+If you are unable to use the DZ Table Maintenance window to Drop & Recreate a DynamicZip table, you can drop (delete) the table using the SQL Server Management Studio. When you delete the table in SQL Server Management Studio, you will need to delete the related stored procedures also. If any of the related stored procedures still exist from the deleted table, DynamicZip will not be able to recreate the table. After deleting the table and its related stored procedures, log back into Microsoft Dynamics GP as sa or DYNSA. Open the [[dynamiczip:​windows:​DZ Table Status window]]. The table may have been automatically recreated if so, it will appear in the scrolling window with a status of successful. If not select **Create SQL Tables** from the DynamicZip menu.
  
 ---- ----
dynamiczip/glossary/drop_recreate_table.txt ยท Last modified: 2017/09/11 20:59 by conni