Developing for Dynamics GP

by David Musgrave (Perth, Australia) and Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Useful SQL Scripts Series

Useful SQL Scripts Series

  • Comments 14

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.

Page 1 of 1 (14 items)
Comments Information


Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 8 and 1 and type the answer here:
  • Post