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

By - April 28, 2017

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


Receive Posts by Email

Subscribe and receive notifications of new posts by email.