ramakantshankar (9/13/2011)

---

Hi,

As you said we can use the SQLCMD to execute operating system commands by indicating the " !! " before the command.

I have created a POC on using OPerating System Commands in a Stored procedure.

Following is the Code for the created Stored Procedure. In the Script for Procedure the Operating Systems commands are used:

CREATE PROCEDURE SQLCMD_TEST

AS

!!MKDIR "C:\TEST"

:OUT "C:\TEST\test.TXT"

SELECT @@VERSION AS 'SERVER VERSION'

!!DIR

GO

SELECT @@SERVERNAME AS 'SERVER NAME'

GO

I am able to successfully execute the procedure:EXEC SQLCMD_TEST

Also if required you can keep the Execute procedure in a SQL script and pass the Script location to the SQLCMD syntax as INPUT file.

Please revert back if this works for you.