Freigeben über

Useful SQL Scripts Series

  • Artikel

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

David

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

  • Anonymous
    November 30, 2008
    From the Useful SQL Scripts Series . This stored procedure allows you to search all columns in all tables

  • Anonymous
    December 01, 2008
    From Vaidy Mohan's Blog http://vmdyngp.blogspot.com/2008/12/sql-series-from-david-musgrave-team.html

  • Anonymous
    December 01, 2008
    From Victoria Yudin's Blog http://victoriayudin.com/2008/12/01/useful-sql-scripts-series-from-developing-for-dynamics-gp/

  • Anonymous
    December 01, 2008
    Posting from the Dynamics GP Blogster http://dynamicsgpblogster.blogspot.com/2008/12/sql-mania-series-at-developing-for.html

  • Anonymous
    December 02, 2008
    From the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction

  • Anonymous
    December 04, 2008
    From the Useful SQL Scripts Series . Because Microsoft Dynamics GP is designed to have separate tables

  • Anonymous
    December 06, 2008
    The comment has been removed

  • Anonymous
    December 10, 2008
    The comment has been removed

  • Anonymous
    April 05, 2009
    From the Useful SQL Scripts Series . I was assisting on a support case recently where we needed to identify

  • Anonymous
    March 08, 2010
    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.   Tom

  • Anonymous
    March 08, 2010
    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. David

  • Anonymous
    June 19, 2010
    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 http://www.gp-dynamics.com which I think a lot of beginning users like me can benefit from. Thank you.

  • Anonymous
    August 04, 2014
    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
  • Anonymous
    August 04, 2014
    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. David