executing dos commands

Question

executing dos commands

Viewing 3 posts - 1 through 4 (of 4 total)

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

james.leeper SSC Veteran Points: 274 More actions · Answer 1

You can either write a batch script to get the required information from the database via a command line, or if you want to do from within the database you can use master.dbo.xp_cmdshell.

Note: This External Stored Procedure is disabled on many databases as it can be considered a security risk.

James Leeper

Database Administrator

WDS Global - Americas Region

James Leeper
Database Administrator
WDS Global - Americas Region

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 2

I would recommend VBSCript to do this. The FileSystemObject can perform file manipulation and the ADO objects can connect to SQL Server.

http://www.mssqltips.com/tip.asp?tip=1324

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 3

Depending on your level of comfort with the DOS gods, I'd recommend either xp_CmdShell or SSIS. If you were to post a wee bit more information using the techinques found in the article at the first link in my signature line below, I'm betting a bunch of folks could give you working suggestions.

--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)