Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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.

 

 

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