# Killer SQL/GP Resource

- URL: https://dynamicaccounting.net/killer-sqlgp-resource/
- Date: 2007-04-10
- Topics: SQL & Data, Development & Integration
- Type: link to an external article
- Source: http://www.4penny.net/

If you work with SQL in GP you owe to yourself to visit the VSToolsforum.com site. Steve Gray of [4Penny.net](http://www.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.