Can you post more details :

DDL of the tables

Sample data (insert dml)

the results you want from the query

your query

the results you are getting now.

What do you want to do in the loop that you can't do in a normal update/insert statement??

BTW you might be interested in reading this.

Arrays and Lists in SQL...

Insert into dbo.LocalTable (col1, col2) Select col1, col2 from LinkedServerName.DbName.dbo.TableName where DateDate between @Start and @End

Look up linked servers in books online.

HTH.

Here's funny anecdote from the same guy. He's a very smart computer guy, almost all self thaught. I mean he could teach me stuff for 3 days straight on...

No need for an acronym finder on this one : NFW you id 10 t .

Is there any other relevant info to copy besides that (like the history).

That'S one more reason to stay away from EM .

Well sometime changed because that fails now... What's the error?

It should... but it would take too long, so every once in a while you get a bad number in there.

What would that be?

You can also use the profiler to find out the slowest running queries and optimize them... and at the same time you could throw that trace in the index tuning...

Can't you just move the most active db(s) to a new server... downtime would be minimal if you move less stuff.

With sysindexes .

Don't think they need a farm for such a small site (no offense)?? I had a server once sending a few M pages/month and it was a PII 500.