Steve Shurts (5/6/2013)
Very interesting... I just had to play and it was fun. However, I can't think of any clever usage for it, yet. But give me time, I'm sure it will become an interesting part of my toolkit. The downside, if you can call it that, is that you have to specify the SQLCMD each and every time you want to run the script, thus restricting it usage for areas where you are trying to automate (e.g. - being able to check a directory for files and running a different stored proc if a file is there...). But cool, nonetheless.
I'm glad you liked this Steve.
Two places where I use it right now:
1. Generic script for setting up log shipping
2. Performing a "dev refresh" by restoring a prod database into dev.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes