I completely agree with Hugo. You said the "best" way, not the way with the least effort (and potentially not the best result). Besides which if you use...

Thanks for your help.

I haven't actually tried any of your suggestions, but very bizarrely everything had sorted itself out the following day.

I have decided to put my efforts into working...

Aha - I have just discovered what the problem was. After the recovery the permissions on the backup folder got changed (not intentionally), so the sql server account no...

It also reinforces the never select * from anything rule!

Choosing the logical answer is quite often not the way to go if you're not sure! Many of these questions are designed to highlight cases where the logical answer...

Since the answer you have is incorrect for SQL 2000, and you never specified which version, can we have our points back please?

I've had occasion to use COLLATE when I needed an accent insensitive search (I needed to find é as well as e when the user typed e), when all of...

This has been very helpful - thank you.

Rachel.

I was wondering whether this is actually the solution to a problem I have, or whether it would be too inefficient.  If anyone has any clever suggestions, then please let...

Ditto.

Can the points be given to everybody who answered A as well as those who answered B?

In BOL it says that REPLACE is only needed if you are trying to restore a backup of a database with one name onto an existing database of a different...

I can't believe that this one got past the proof readers after the similar question we had the other day!  It has exactly the same syntax error as that quesion did...

Thank you.  This has been very helpful.

I agree - there is no "WITH" in the first statement before the NORECOVERY, so you get an error - i.e. "An error occurs because the first restore statement is...

Doh!

You're quite right - the results come from several tables.

To be honest I never actually wanted to update the data using the ADO recordsets anyway, since all our database updates...