xp-cmdshell

相关标签：javascript jquery android 多少钱 iPhone

Trying to delete folder contents using SQL Server 2008 R2

I am executing xp_cmdshell from the SQL query editor to delete a file in a folder but getting a two rows as result; the first row contains a me开发者_StackOverflow社区ssage \"The system cannot find th[详细]

2023-04-05 04:31 分类：问答
Console app doesn't print when executing with xp_cmdshell under sql server agent proxy

I have a requirement to automatically print an ssrs report to a specific printer on the network whenever a n开发者_运维百科ew row is inserted into a database table.There is a trigger on the database t[详细]

2023-03-24 09:45 分类：问答
Microsoft SQL xp_cmdshell doesn't like filenames with spaces. Can I replace the space with something else?

I have this TSQL code that dumps data from tables using BCP.It looks complicated, but it simply creates a @command string to be executed once for each table, then BCP dump the table records to disk.It[详细]

2023-02-23 01:24 分类：问答
xp_cmdshell copy command seldom fails

I am running SQL Server 2005 on Windows Server 2003 machine. I have a requirement to accumulate small text files into a bigger one.[详细]

2023-02-12 03:21 分类：问答
call xp_cmdshell with xml parameter

It was created console application that has two param: one is a command like \"send\"and second is a xml string like \"<Messages><msg>My message</msg></Messages>\". Console app[详细]

2023-02-04 13:47 分类：问答
tsql Loop with external query

I am looping through all my databases and aggregating the results into an aggregates database. In my loop I call[详细]

2023-01-12 22:08 分类：问答
Check services at startup of SQL Server

I am trying to check the state of services when SQL Server is started. I am using xp_cmdshell and \'sc query SQLServerAgent | FIND \"STATE\"\' for example to load the output to a global temp table. It[详细]

2022-12-31 05:30 分类：问答
I'm missing something

declare @servername varchar(2000) set 开发者_如何学Go@EmriServerit=(select @@servername) declare @dbname varchar(2000)[详细]

2022-12-26 03:40 分类：问答
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 enabled on the instance. And the execute permission was granted to my user, but I am sti[详细]

2022-12-15 12:31 分类：问答