Useful SQL Scripts Series

David MeegoAfter the success of the Microsoft Dynamics GP Application Level Security Series, I have decided to release a another series which contains some really useful SQL scripts I have collected over time.

The posts in the series (so far) include:

Note: Links will be available on or after the posting date.

I hope you find the information in this series useful. I plan to add more scripts as time goes on.

If you have any scripts you wish to donate to the series, please contact me using the Email link at the top of the blog page.

More scripts available from


02-Dec-2008: Added Link to Mariano Gomez's article.

06-Apr-2009: Added Identifying Payables Transactions with Missing Apply Records post.

21-Jun-2010: Updated links to other blogs for additional scripts.

03-Nov-2010: Added Backing up and Restoring script.

05-Dec-2011: Added Granting Access and Binding Defaults script.

31-Jul-2013: Added link for updated spSearchOnAllDB script.

Comments (14)
  1. From the Useful SQL Scripts Series . This stored procedure allows you to search all columns in all tables

  2. From the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction

  3. From the Useful SQL Scripts Series . Because Microsoft Dynamics GP is designed to have separate tables

  4. David,

    I found another script you may need to add, check my post below:


    Mohammad R. Daoud

  5. From the Useful SQL Scripts Series . I was assisting on a support case recently where we needed to identify

  6. Tom Garth says:

    I recently wrote a script to synchronize a newly updated TEST company’s users with the Dynamics user access list. Do you accept contributions? If so, how should I submit it? Or is that script already here. I searched, but couldn’t find it.


  7. David Musgrave says:

    Hi Tom

    You can email the script to using the feedback link at the top of the blog.

    I am always interested in looking at handy SQL scripts.


  8. Scott Tilley says:

    Glad to find many great Dynamics resources as it makes learning/teaching the subject so much easier. I wish I could give back by writing and sharing my own script commands but I'm not that proficient yet in this field. There are many more useful Dynamics GP scripts on which I think a lot of beginning users like me can benefit from.

    Thank you.

  9. Tom Searl says:

    I am looking for a couple of scripts to automate a couple items…

    1. to push in a GL Transaction (I currently use the integration Mgr and I want to totally automate it)

    2. to create a check batch

  10. David Musgrave says:

    Hi Tom

    Please look at eConnect as this is the recommended method of integrating transactions. It has an API which in turn calls SQL Stored Procedures which include all the business logic and validation.


Comments are closed.

Skip to main content