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

top-5-list-of-commonly-used-sql-scripts-in-dynamics-gp-1

Batch Stuck

top-5-list-of-commonly-used-sql-scripts-in-dynamics-gp-2

Find Tables based on Field Name

top-5-list-of-commonly-used-sql-scripts-in-dynamics-gp-5

Grant SQL

top-5-list-of-commonly-used-sql-scripts-in-dynamics-gp-4

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

 

Tagged with →