Contents tagged with xp_cmdshell
-
SQL Server: Troubleshoot xp_cmdshell
http://www.sqlpanda.com/2011/10/trouble-shooting-xpcmdshell.html
https://www.techtalkz.com/threads/granting-xp_cmdshell-permission-to-sql-login.190618/
-
SQL Server: Deleting Files with TSQL
http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx
https://stackoverflow.com/questions/43269779/how-to-delete-files-on-the-directory-via-ms-sql- … more
-
SQL Server Autonomous Transaction Within View
/* create a function that inserts to a table via xp_cmdshell */
CREATE FUNCTION dbo.fn_write_to_table()
RETURNS int
AS
BEGIN
DECLARE @sql varchar(MAX), @cmd varchar(4000)
SELECT @sql = ' … more