How To Recreate SQL Objects Using PSTL

Microsoft Dynamics GPAs 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;


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.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

3 thoughts on “How To Recreate SQL Objects Using PSTL

Leave a Reply

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