Eugene Elutin (2/11/2014)
Why not just a simple script (in whatever scripting language) which executes proc and outputs into file in a better location.
I know it'll be viewed as a personal preference but I try to limit the number of languages used so that you don't need many "experts" nor are you in trouble if the one or two people that use the scripting language leave the company. I'm also adverse to having to use scripts rather than nice, neat stored procedures where I always know where the source code is even if someone screws up SVN.
--Jeff Moden
Change is inevitable... Change for the better is not.