Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Advanced
Aug 19, 2002



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Running DOS Commands in SQL Server Query Analyzer

If you run this statement In SQL Server Query Analyzer:
EXEC master..xp_cmdshell 'dir *.exe'

You will get the result as DOS DIR Command. Using this, you can run all DOS commands.

A sample result looks like this:
09/21/01  08:25a                26,384 actmovie.exe
09/24/01  10:07a               118,032 addgrpw.exe
09/21/01  08:25a               155,920 addusrw.exe
10/14/96  07:08a                10,774 append.exe
04/29/99  12:04p                21,264 ARP.EXE
10/14/96  07:08a                27,920 at.exe
04/29/99  12:04p                22,800 ATSVC.EXE
10/14/96  07:08a                27,920 attrib.exe
09/21/01  08:25a               153,088 AUTMGR32.EXE
Somaiah Manukonda
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date