Not to be a nitpicker, but the above actually stores the value as a datetime with the time = 00:00:00AM (i.e. Jan 23 2004 12:00AM). This makes date math work...

You posted this question THREE TIMES! You will get better response if you're more careful to post a question only once. You got an answer from my on one thread,...

Gary,

Is there someplace this process is documented? I'd love to get rid of connection strings, but our primary IIS server accesses a large number of databases each of which has...

I believe the connection information is sent in clear text unless you're using an HTTPS connection.

We code the connection string and "conn.open" statement in an including file (i.e. connection.inc), use...

Duh... I should have looked at BOL first!

Thanks.

This looks very interesting. Can we get it uploaded to the Scripts library rather than trying to cut/paste from the Forum?

I don't want to stop processing, I want to branch around a set of tasks that are run only if duplicates are present, and resume processing at the next task...

This might work. I suppose I can do all the duplicate record handling in the ActiveX: If duplicate_count>0 then select the duplicate info, build the email, send it then delete...

Thanks both. I'll have to look into assigning the output of a query to a global variable. I know the theory, but never did it. The second answer leads me directly...

Nested Stored Procedures or User Defined Functions (UDF's) are the best ways to modularize (?) code in TSQL.

I've found it easier and safer to use DTSRUN and generate a Windows BAT file to execute the DTS package, then schedule that via W2K Scheduled Tasks.

Assuming I want to write an ASP app that can display BLOB's stored in a database (i.e. Employee pictures), is it absolutely necessary to retrieve the BLOB to a file...

Not only are the Response.Writes an issue, but you really don't want to return DTSTaskExecResult_Success if the folder wasn't copied, right?

Try this. It will return a failure for the...

I had the exact same problem with an ASP application updating tables almost exactly the same size. I did a couple of things:

1. Added indexes where appropriate to speed up...

If I'm not mistaken Stored Procedures return only one RecordSet. You may need to use the NextRecordset method on the returned Recordset to access multiple RecordSets returned from a Stored...