What's wrong with the CONVERT-function??? I never needed a date format that was not readily available through this function. It's also much much quicker than this CASTing and concatenating.

Albeit that...

For deploying sp's (which are located in a script called C:\mySP.sql) you can use:

SET @mySQL = 'CALL isql -S' + @InstanceName + ' -E -i"C:\mySP.sql" < and the rest...

I use SETUSER statement on rare occasions to quickly determine of the security settings of a Windows-account are correct (or to check if allegations made by a user are correct