I thought it was a excellent question. I also choose the wrong answer but I learned something new. Thank you Steve

I use SSIS and cuteFTP (Pro edition) if I am dealing with protocols like SFTP or HTTPS

I am using the staging table and verify in a case statement if it is valid date to write to the production table.

Hi,

we have not been able to figure out what is causing the problem. We decided to use the 64 bit system for different databases and kept the database with the...

Assuming you can setup a ODBC connection on the box with the Excel Template, let the stored procedure write the report data to a temp table. In Excel at...

Jack Corbett (12/11/2008)

---

Have you compared the execution plans?

What version of SQL Server 2005 std, enterprise? There are differences in memory use in the 2. Is SQL Server using...

Thanks for your response. Right now the tempdb resides on the same drive than all the other db files. The OS is on the C:\ Drive and the ...