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.