Based on the success of the "Resolving Security Issues in Dynamics GP" located here, Microsoft Dynamics GP Application Level Security Series, Dave has created a new series on "Useful SQL Scripts". I can tell you that I used all these many times over when I was a consultant and you will find them very helpful and will use often.
The posts in the series include:
- 01-Dec: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
- 03-Dec: Releasing Stuck Batches and Transactions without exiting all Users
- 05-Dec: Identifying Duplicate Transactions
Additional scripts will be added as times goes on, so check back periodically to see if new scripts have been added.