This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
After 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:
- 01-Dec-2008: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
- 03-Dec-2008: Releasing Stuck Batches and Transactions without exiting all Users
- 05-Dec-2008: Identifying Duplicate Transactions
- 06-Apr-2009: Identifying Payables Transactions with Missing Apply Records
- 03-Nov-2010: Backing up and Restoring data when recreating SQL Tables
- 05-Dec-2011: Granting Access and Binding Defaults when recreating SQL Tables
- 31-Jul-2013: Updated: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
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
- Mariano Gomez at SQL-mania series at Developing for Dynamics GP
- Mark Polino at Updated Downloads and SQL Scripts
- Victoria Yudin at SQL Code Tag
- GP Dynamics Custom programming at Collection of useful Microsoft Great Plains Dynamics Sql Scripts, Tips and Tricks
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.
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.
From the Useful SQL Scripts Series . This stored procedure allows you to search all columns in all tables
From Vaidy Mohan’s Blog
http://vmdyngp.blogspot.com/2008/12/sql-series-from-david-musgrave-team.html
From Victoria Yudin’s Blog
http://victoriayudin.com/2008/12/01/useful-sql-scripts-series-from-developing-for-dynamics-gp/
Posting from the Dynamics GP Blogster
http://dynamicsgpblogster.blogspot.com/2008/12/sql-mania-series-at-developing-for.html
From the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction
From the Useful SQL Scripts Series . Because Microsoft Dynamics GP is designed to have separate tables
David,
This script maybe useful:
http://mohdaoud.blogspot.com/2008/12/how-to-delete-gp-company.html
Regards,
Mohammad R. Daoud
David,
I found another script you may need to add, check my post below:
http://mohdaoud.blogspot.com/2008/12/search-all-columns-of-all-tables-for.html
Regards,
Mohammad R. Daoud
From the Useful SQL Scripts Series . I was assisting on a support case recently where we needed to identify
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
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
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.
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
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