If you work with SQL in GP you owe to yourself to visit the VSToolsforum.com site. Steve Gray of 4Penny.net continues to put out great, useful SQL scripts for GP. Recent items included T-SQL code to create an audit table and trigger, info on renaming a SQL server, sending query results to text files and outputting all of the Stored Procs, Triggers and Functions to a text file for easy searching when something has gone wrong. It’s important to note that Steve does a ton of work with GP so the scripts here are often GP focused, not just generic SQL stuff. Anybody who names a post “SOP10200 Fields” has a clue about GP.
Steve is the guy who helped me pull together all the scripts we use for daily balancing. In addition to being a SQL witch he’s a genuinely nice guy who giving back some great info to the GP community.
Killer SQL/GP Resource
SQL & DataDevelopment & Integration
Archived post from 2007. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.