Nothing so far.

Andy

I havent worked much with asynchronous queries - will have to look! Are they using ADO, ODBC, ??

Andy

I'd take a second look at DTS. You can certainly create complicated packages, but for just moving data from one place to another it's hard to beat. While the GUI...

What is TSO?

FTP doesn't have anything to do with SQL really, even the FTP task in DTS is just a wrapper around basic Windows functionality. You can use the http://FTP.exe...

Seems like there should be, but it doesn't spring to mind. Building the string and using Exec() would certainly work. Another solution, not pretty, would be to do something like...

You're right, I probably should have included it. Just so hard to figure out what is "basic" and not write a book instead of an article:-) I did include it...

SQL has use of the entire 1G? 1G aint as much as it seems like!

Andy

MS has a tool called LoadSim (I think) in the Back Office resource kit that will run scripts on up to 60 or so threads from a single client. Not...

Never heard of it - seems pretty strange!

Andy

I've never used Oracle, so I'd have a hard time as well. I think overall I feel that SQL Server is a solid product that is probably more than good...

Take a look at filegroups. Not my favorite solution, but a valid technique. Hopefully you're adding a RAID set and not just a single drive?

Andy

Steve, I think the problem is not every job or company needs the skills of a CPA or a PE. Have you read After the Gold Rush by Steve McConnell?...

Doesnt seem to be possible. If you look at the sp_runwebtask it just hands it off to an extended proc that's in a dll. The data in the wparams looks...

I'll have to admit to NEVER having done a silent install. Does it happen only on NT boxes or on Win2K machines as well?

Andy

Andy

How about posting your code? I'd suggest checking it separately, perhaps in a .vbs file. You can throw in some msgbox's to help you see what is happening.

Andy