Top 5 List of Commonly Used SQL Scripts in Microsoft Dynamics GP

Favorite SQL Scripts

These are my most commonly used SQL scripts on every Microsoft Dynamics GP implementation that I perform, now compiled in one place.

One caveat, always, always, always have a RESTORABLE backup, in case something undesirable occurs and try this on a test server or test company first. Please use these queries with caution.  IMPORTANT: Commands with UPDATE, DELETE or DROP can ruin your data! I have remarked those commands out as a further precaution, so they are not run inadvertently with the Select statements.

So here they are in no particular order:  (Imagine a drum roll at this point!)

User Activity

Batch Stuck

Find Tables based on Field Name

Grant SQL

So those are some of my most useful scripts. Please leave a comment and let me know some of yours.

Want to know more about working with Microsoft Dynamics GP? Contact our Dynamics experts 855-437-7201

by Danielle Edie for RSM

RSM Staff