sqlcmd code in stored procedure

• Vasu-709835

  SSC Eights!

  Points: 921

  More actions

  November 20, 2009 at 5:48 am

  #99965

  Hi

  My qusetion:

  i want export Table data to text file usind sqlsmd?

  but i have to run sqlcmd code from stored proc..

  i am able to export data using below command at command prompt:

  sqlcmd -S server1 -U testuse -P test@123 -d citidb -Q "select * from

  [table1](nolock)" -o "MyData.txt"

  but how can put the above code in Stored procedure

  so that i can execute that sprocedure..

  i dont want to use Xp_cmdshell in Stored procedure

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  November 20, 2009 at 7:08 am

  #1082196

  If you don't want to use xp_cmdshell then

  1. Create a job with step of Type Operating system (CmdExec) and type you sqlcmd command in that.

  2. Then from the stored proc execute sp_start_job to start that job.

  -Vikas Bindra