xp_cmdshell and Windows Apps

Question:
Why can’t I run an application like ws-ftp from SQL with xp_xmdshell? ws-ftp will start, but it’s not visible on the screen.

Answer:
xp_cmdshell runs in the space of SQL Server; it doesn’t open a window on the command prompt. I would be very careful as to what I do with xp_cmdshell in order not to destabilize the Server.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: