Executing a batch file from T-SQL

Question

Post reply

Executing a batch file from T-SQL

Mark Fyffe

Old Hand

Points: 376
More actions
February 28, 2007 at 8:24 am

#116461

I am looking to start a batch file from Transact SQL in Query analyzer and ultimately in a job does anybody have code that does this? Or can it be done?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

SQL ORACLE

One Orange Chip

Points: 27807

February 28, 2007 at 8:28 am

#692317

Did you try master..xp_cmdshell?

Mark Fyffe Old Hand Points: 376 More actions · Answer 2

Please provide an example -- I tried using it but I think I am using it incorrectly.

Terry-239890 Ten Centuries Points: 1387 More actions · Answer 3

Read this in the forum: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=347999

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 4

What kind of error are you getting... you might also post your code so we can help more. And, don't forget, you must have "SA" privs to use it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

vadba SSChampion Points: 11133 More actions · Answer 5

Assume you have a batch file called TEST.CMD located in C:\ on your server that contains this code:

@echo off

echo This is TEST.CMD

pause

To run this from Query Analyzer using integrated security, you could execute this:

exec master..xp_cmdshell '"c:\test.cmd"'