If you have office 2007, you could consider using sharepoint or analysis services so that they can manipulate the data themsleves (all in excel for the GUI). They would...

should be 0 with only 28 rows. does that include the script generation?

Just did a test on my laptop, 4 M rows (3 columns wide) >> 50 Mb of data. data generation 4 seconds, export 6 seconds, import 5 seconds.

Lenovo 1.9...

You could also have the server spend the week-end with my parents. That would be a very fair test :D.

Isn't there a tool at redgate that does stres testing?...

That should help :

zip

ftp to sql server

unzip

run import.

I have a crappy computer here and an import like that wouldn't take more than a few seconds.

Just for the fun of...

How big is the file and how long does it take you?

How many columns and how much data do you have to process?

Where do I send my resume? I'd love to help out on that project.

Why "load it" in access since SQL Server is the data server in this case.

You can base any reports, diagramsor whatever you need from a query on that data on...

You seem to understand the question really well. Now I don't know if you know the correct answer tho :D.

BTW about 50% got it right, so it's definitly not...

and then ...look up books online in books online...

Sorry Gail, I know I'm not supposed to read your mind :D.

Hey Gail, I'm stuck in an environement like that where it was installed CS. Have you found any advantages of using CS collation?

something like sp_msforeachdb?

Well you actually get paid for that... you used to anyways.

I'm sure you can trade in for a shirt :D.

You better drink it then, I'm not into alcool all that much.

Thanks for the thoughts. 😛

You need to put a prefix in front of the function (sorry I don't remember it).

It's like Code.FunctionName (parameters, go, here).

Again F1 with keyword search function should lead you to...