Top "Xp-cmdshell" questions

an extended stored procedure provided by SQL Server, which launches a Windows command shell to run a specified command.

Reading a text file with SQL Server

I am trying to read in a text file from an SQL query (SQL Server 2005) but am not having any …

sql-server sql-server-2005 xp-cmdshell
Getting execute permission to xp_cmdshell

I am seeing an error message when trying to execute xp_cmdshell from within a stored procedure. xp_cmdshell is …

sql-server database xp-cmdshell
Get Results from XP_CMDSHELL

I have been searching the web some and it seems like the only way to get the results from XP_…

sql-server stored-procedures xp-cmdshell
Access denied for enabled xp_cmdshell for the admin user

I'm using xp_cmdshell within a database trigger to launch a exe file. xp_cmdshell is enabled(it can execute …

sql-server windows sql-server-2008 permissions xp-cmdshell
How to delete files on the directory via MS SQL Server

I am trying to delete a file from a directory inside windows using the following query, exec xp_cmdshell 'del "…

sql sql-server xp-cmdshell
using BCP to export stored procedure result in SQL Server 2008

Heyy, I'm trying to use BCP to export a SP result to a text file using this query: EXEC xp_…

sql bcp xp-cmdshell
SQL xp_cmdshell copy files between servers

I am trying to move all .zip in a specific folder to another folder. the source folder is located on …

sql sql-server sql-agent-job xp-cmdshell
How do I check if a directory exists using SQL Server?

I know this command will create a directory: EXEC master.sys.xp_create_subdir 'C:\testing\' But how do …

sql sql-server directory xp-cmdshell
xp_cmdshell Native Error 208, BCP in SQL Server 2008 R2

I've been trying to work on taking the result of a large and multiply-joined SELECT statement, and email the query …

sql sql-server-2008-r2 bcp xp-cmdshell
Enable xp_cmdshell does not work

I try to enable xp_cmdshell in SQL Server. So I ran: EXEC master.dbo.sp_configure 'show advanced options', 1 …

sql-server sql-server-2008-r2 xp-cmdshell