Hi Kendal,

Thanks for your reply!

Most of our Data Warehouse resides in 2 databases - currently one 300GB and one 400GB. I don't think I'd have the disk...

20GB is a decent chunk of data, any way to identify data that changed over the past 24 hours and just send that? How about using replication?

Otherwise you could...

GSquared is right, SQL Agent is the best way. Sometimes bosses need a little education in these matters...

If that doesn't work 🙂 you can create a DOS batch file...

Gunaseelan,

Thanks! That code snippet helped me solve an issue I had using the FTP Task to receive a file from a Tandem (HP Nonstop) server.

The FTP task wouldn't let...

Hi James,

I found a good article about doing multiple files in a directory...

http://www.databasejournal.com/features/mssql/article.php/10894_3325731_1

But I think John's right - the best thing to do is to schedule the...

Hi John,

Thanks for the suggestion!  That pointed me in the right direction.

Actually the activex trim function of { "Fred"} made the string import as {"Fred"} (with quotes) into the SQL Server table -...

Hi Shawn,

Thanks for your reply.

I don't think the ulodctr/lodctr will work for this problem because nothing is getting into master..sysperfinfo. When I executed unlodctr on a test box (not...