Thanks, that helps. I have heard memory leaks in SQL Server itself are extremely rare at this point, however paranoia prevails at times so I am investigating. The consensus of...

You could certainly do that. Either way, whether SQL Agent or Windows Task Scheduler, I would favor PowerShell over VBScript in every conceivable use case.

OK 😛

Sure...but how would you copy the file...

Just about anything would...

BTW, IMHO stands for In My Humble Opinion

PS BTW stands for By The Way

I would strongly advise against trying to write a file from within a trigger. A more sound approach would be to:

1. Create a staging table to hold the data you...

A more reliable way to find machines than using NET VIEW is to select directly from Active Directory. This post has a nice script I refer to from time to...

Ed.Watson (12/21/2011)

---

I think the script is backward, it is deleting the PDF when the CSXML is there. I need it to do the opposite, if there is no CSXML...

I can recreate the issue using the "Server Installation Settings" facet. I can use the ExecuteWql function using the "Server Information" facet however @EngineServiceAccount is not a property of that...

There is no need to use xp_CmdShell here. You can do this using PowerShell directly from within your Job. In SQL Server 2008 a PowerShell job step type is available...

blah...

I think the OP may mean Triple DES which is typically abbreviated TDEA, not TDES.

You may be comparing apples to oranges but I cannot say for sure because I do...

There are many better ways (IMHO) to get XML from a database to disk than from within a T-SQL context. Have you exhausted all other options? What is your client...

I imagine it is possible to do this using the pipeline with far less code but this will get the job done:

$dir = "C:\@\1"

foreach($file in (ls "$dir\*.pdf"))

{

...