http://technet.microsoft.com/en-us/library/ms156285.aspx

look for more resources on msdn they have a very good repository

write the script first, then post if you get problems. your requirement is very vague

i am being thick  probably but I am thinking you could run the 2 queries and tell us which one is faster.

DECLARE @data_path nvarchar(256);

SET

@data_path = 'What ever you want'

--execute...

with Access 2007 now entrenched in the business world you still get the odd one having Access 2.

But my classic experience will be the one i encountered DB IV, gosh.

The long...

and I have hardly started using sql 2005

write the script then we will help if you get errors

an ardous solution you have proposed.

why not just take the db down for maintenance and do what you want. after all the alledged 24/7 systems that i have encountered have...

i think i am thick, i am failing to understand your question

consider using reporting  services, where u can schedule report generation and delivery

the fastest and simplest is detach and attach. but follow the advise above in case anything happens

have a look at your query plan it will show you where the time is going