an extended stored procedure provided by SQL Server, which launches a Windows command shell to run a specified command.
I have this TSQL code that dumps data from tables using BCP. It looks complicated, but it simply creates a @…
sql-server-2005 tsql batch-file xp-cmdshellI am trying to access a folder/directory using 'EXEC MASTER..XP_CMDSHELL' it works for the local file/folder, …
sql sql-server-2008 file-access xp-cmdshellHere is code which I use to create a .rar file with a password DECLARE @source VARCHAR(1000), @destination VARCHAR(1000), @Command …
sql sql-server sqlcmd xp-cmdshellIs it possible to return output parameters from a SSIS "Script Task" that has been called by a stored procedure …
ssis sql-server-2008-r2 xp-cmdshellI am creating files with xp_cmdshell like this: SELECT @command = 'echo ' + @fileContent + ' > e:\out\' + @fileName + …
file sql-server-2005 utf-8 xp-cmdshellI have a problem with a hang using xp_cmdshell. The executable is called, performs its work, and exits. It …
sql-server-2008 xp-cmdshellI can't seem to find the right syntax to export data with column names using exec xp_cmdshell bcp in …
sql-server bcp xp-cmdshellI am using the below code snippet to FTP simple text files from a Windows Server 2003 / SQL Server 2005 database to …
sql tsql sql-server-2005 ftp xp-cmdshellLooking to just map a network drive with a different AD account in a SQL query. XP_CMDSHELL is disabled …
sql-server tsql xp-cmdshell net-useI am getting Execute permission was denied on the object 'xp_cmdshell'. Here's the situation, I have a stored procedure …
sql permission-denied xp-cmdshell