in reply to Automating SPROC execution
In general, searching for a script that completes the whole task you want done isn't going return results. Instead, I'd plan it out and focus on particular parts of the problem, and search on those. In your case you want to:
- Connect to your database
- Find files in several directories
- Open those files once found
- Perform a substitution
- And finally, execute the SQL statements found
My suggestion would be to start trying to build these pieces (maybe after searching on them as prepwork), and ask here about your specific roadblock if you encounter one. Provide code! Or, if you don't know where to start on a particular piece, say so here and I'm sure somebody will give you a jumping off point.