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;

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.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.