bitbucket-25253 (9/17/2013)
You might want to read thishttp://www.sqlservercentral.com/Forums/Topic1173815-392-1.aspx#bm1173927
and determine if the use of !! to execute operating system commands will work in your environment.
If you do test ... please post your result (success or failure) so that others may learn.
Hi Ron,
Sorry I understood need to enable SQLCMD and it works fine. But for me the situation is have many procedures which has several OS commands and also SQL commands(including cursors) ,And think we cannot keep or it would be challenging for SQLCMD to be ON for executions of procs with OS commands and without OS commands. I am stuck now. Google unable to help too...anyone have idea? please do reply.
regards
Raj