Thank you for that Lowell

That worked perfectly.

Thanks again

Oh ok i see, so if i were to say:

UPDATE MYVIEW SET FIELD1 = 1

Would that update field1 for all records that are returned in view?

Hi Lowell

It isn't the view that i want to update, i want to update the contact table but only update the clients that appear in the view.

I thought about doing...

Looks as though this backup was taken after changes were made, will it only ever keep 1 backup?

I think this backup was taken about an hour before the data was removed but i am going to try and restore this backup over a new database and find...

Looking again at the MSDB database, there was a full database backup created this morning. How do i found out where these backups are?

I have checked the MSDB database and it doesn't contain the database needed. I'm guessing there will not be any recovery tools that may work? Something like a system restore...