How To Recreate SQL Objects Using PSTL

As well as rebuilding a corrupt GL00105, the Toolkit within the Professional Services Tools Library (PSTL) can be used to recreate SQL objects such as SQL Indexes or the Dex stored procedures.

To use the PSTL Toolkit to recreate SQL Objects, open PSTL and then select Toolkit in the System Tools section and click Next;

Professional Services Tools Library

The first thing on the next window is a caution that a backup of all databases should be done before running the toolkit (backup both the company and system databases). There are two choices on the window the second of which is Recreate SQL Objects;

Toolkit

In this example, I’ve selected the Series of Financial and the table TWO.dbo.GL00100 and Rebuild Indexes for Selected Table before clicking Perform Selected Maintenance;

System Diagnostics

Once completed a dialog will be displayed confirming the recreation of the indexes has been completed;

Microsoft Dynamics GP - Indexes for TWO.dbo.GL00100 have been recreated.

To show a second example, I’ve selected Recreate Tables for Selected Series and checked the Recreate data for selected table(s) to make sure data is not deleted (this option works with both the option I selected and the Rereate Selected Table option above);

System Diagnostics

Click Perform Selected Maintenance and you will recive a warning message about recreating triggers;

Microsoft Dynamics GP - Recreating tables with data. Any existing triggers will have to be recreated. Default triggers can be recreated by using the triggers.cmp or triggers.sys scripts that load with a client/server install.

Click OK and a second warning message will be displayed to confirm, in this instance, that the Financial series tables will contain data after being recreated and to verify that a backup has been made;

Microsoft Dynamics GP - 'Financial' series tables will contain data after being recreated. Verify a backup has been made before proceeding.

Click OK to see the final warning about how the process may take a while depending on table sizes;

Microsoft Dynamics GP - Recreating all tables with data may take time depending on tables sizes in the 'Financial' series.

Once the recreate has completed a dialog will be displayed confirming this;

Microsoft Dynamics GP - All tables for the 'Financial' series have been recreated.

3 comments on “How To Recreate SQL Objects Using PSTL

  1. Pingback: How To Recreate SQL Objects Using PSTL | Interesting Findings & Knowledge Sharing

  2. Pingback: How To Recreate SQL Objects Using PSTL | azurecurve – 6/12, DynamicAccounting.net | Partner Compete

  3. Pingback: How To Recreate SQL Objects Using PSTL | azurecurve - DynamicAccounting.net - GP Technical Blogs - Microsoft Dynamics Community

Leave a Reply

Your email address will not be published. Required fields are marked *

*

* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>