I was copying the exact code from inside the view and just added the "WHERE ID = 123" bit at the end, compared to running the view "select * from...

I am not sure if it works on R2 but SSMS Tools provides an option to run a script across multiple databases on the same server very easily.

The script produced...

thanks for the reply, where I am missing something is according the the Network admin the Windows accounts are going to be newly created on the new domain thus having...

it is definitely possible to access the DB, it can be in a Restoring state or a Read Only state, the catch of cause is the exclusive acccess needed by...

What I still do not understand is why the data in the log file was very small (< 1GB) yet the transaction log backup files was ~40GB.

I thought what was...

What I am doing is upgrading from SQL 2000 to SQL2008. The databases will be going to a completely new server so I have the luxery of setting up the...

Thank you, so is there any I can do to prevent such a big log file?

Would a re-organise create a lot less data and a full index once a week?...