tryusing sp_executesql, it does parameterized batches for a TSQL statement you design and addresses most of the issues raised here. See BOL for more.

A clustered index is SORTED. So after each and every insert you are re-sorting your data. A few things come to mind:

1) remove the index, insert batch, re-build the index

2)...

Please clearify: Exchange Server's message queue gets backed up....

We send close to 50k emails every morning, using Windows2003, CDONTS, Exchange and SQLServer. The scripe is written in VBScript and runs...

would be most efficient to change this query to:

where not exists (Select 1 from table1 where JOIN STATEMENT)

The specification for an XSD can be found at: http://www.w3.org/XML/Schema

Microsoft extends this for use with its parsers and SQL Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp

I have yet to find a single tool...

just ran a test on the same server, set a job up, disable, but with current schedule. ran profiler, no outside process set it off, it was the sqlagent ???

nope, local.

nothing else calls these jobs.

generally it is not sp_prepexec that is the root cause of 100% cpu usage, it is usually a very poorly formed query/design. sp_prepexec is used by ODBC and OLE to...

You can also use the DTS Multiphase Pump or a simple lookup script against the offending date column, all within the Data Transfer task.

T-SQL will not do the trick, the quickest way is to open up the packages and execute some VB code from an ActiveX task, assuming the passwords you are talking...