I suspect only nominal.  Probably not enough of a saving to warrant even the few seconds spent clicking or typing the files into existence.

Jeff - 12 GIGABYTES??  GEEEEEEEYAAAZUS man, what...

Excel has long been a passion of mine but one I never had time to indulge!! 

Jaybee.

The error occurs at the start and doesn't rectify itself.  I'll find out about QA.

That's fascinating, this concept of having as many CPU's as TempDB datafiles.  I had always just contented myself with a single TempDb.mdf at 100Mb, a TempDb.ldf at 40Mb, and both spliced...

Brilliant answer, Jeff.  I would extend the small-company "hat" out to vendor-battler, DTS-fixer, and occasional OS/Hardware support.

Jaybee.

Can we assume that the restore was successfully rolled back??

Sugesh,

Is there a way to do this in QA?

Cheers,

Jaybee.

Carl, I'd like to thank you much for that!!

Just a couple of questions though,

What FTP softwares can restart?

Why not query linked servers?

How large would data have to be to...

Sorry, I've worked it out - I was forgetting that this was a code to create the SP to optimise future insertions - not immediately execute one.

My bad, Lynne thanks...

It's ok...problem resolved...somehow????

I reloaded the SAME active X script for the lookup, and it decided to work.  Only one thing I hate more than a problem I can't solve -...

Amen to that.  The only good Recruitment Consultants have body temperatures hovering slightly above zero.

That said, my last agent was an exception, an absolute diamond top notch fella, went out for...

In my SQL Server experience (same length as yours, wide variety of environments, but little/no non-prod work), the factors that govern marketability are, in descending order of significance:

Skillset/frequency of use;

Size/variety...

Ninj,

These requests are on behalf of a good (DBA) friend of mine who would like me to express his deepest gratitude, it was "Very nice of him, he must be...

Hi Ninj,

This is exactly what I wanted!!!  Ok, which part of Access must this be implemented in??  Ie, queries, stored procs, VBA, etc??

Cheers,

JB.

Hi Tim,

Appreciate that, I wanted to know if there's a way to do the same thing programatically, so that I don't have to manually enter any records??

Cheers,

JB.