EXEC XP_CMDShell running in SSMS 2012

Question

EXEC XP_CMDShell running in SSMS 2012

sulman.sqldba

Old Hand

Points: 391
More actions
April 18, 2016 at 9:52 am

#306645

EXEC XP_CMDSHELL 'net use /delete *'
Need to find out how to feed a "Y" answer into the execution of this command.
Trying to delete this post!

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

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

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

sulman.sqldba (4/18/2016)
EXEC XP_CMDSHELL 'net use /delete *'
Need to find out how to feed a "Y" answer into the execution of this command.
Trying to delete this post!

Add a /y to the command line.

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

xp_cmdshell isn't interactive, so anything you run here would have to run without any additional input from the command line.

I have been able to automate things like http://ftp.exe by using an input file. Have commands in a text file that are sent to the exe with a < (input)

Ref: https://technet.microsoft.com/en-us/library/bb490982.aspx