Curious what the errors were, but using a table is definately a good solution.

This could be done without a cursor. What would help us help you better would be if you could provide us with a setup that reflects the problem at...

Are you getting some kind of error?

I have to agree with Lowell on this one. I could easily spend my entire weekend working on this one, but not willing to do that for free. ...

We can always hope. Good luck, as I am currently out of ideas. Plus, it's time for bed.

Here is the best way to think about it. We are volunteers with our own jobs that need to be done. We don't have access to your systems....

Just a tip, the more you tell us, the better help you will get. I am not working in a clustered environment. We are, finally, setting up a...

Is the other DB on the same drive? If so, hate to ask this, but, have you tried rebooting the server?? <ducking quickly to avoid the pork chops...

That is telling me the SQL Server can't find the files on disk. What exactly is the F: drive, direct attach storage or a SAN?

Anything in the logs, SQL or Error?

Jeff Moden (2/3/2010)

---

Lynn Pettis (2/3/2010)

---

mark.veitch (2/1/2010)

---

Thank you very much Lowell. Just had a quick scan and although this is new to me I'm thinking it might be a possibility....

Just thought I'd throw in my two cents. Buying the Developers Edition is well worth the expenditure. Plus, if you look around, you can find it for usually...

DHeath (2/3/2010)

---

Well hmmmmmm not sure i know how to show you what i was doing because i used SSMS to do the database restore and with this all being...

Thank you. And thank you to everyone else. I actually couldn't have done it without the assistance of all...

matt stockham (2/3/2010)

---

It looks pretty good. There are a few other areas that you may want to investigate:

1) The bad data could still be in server memory - reboot...