I need the row except when both NOTs are true. As it stands I don't get the row if either NOT is true.

If your view just returns a recordset, why not just replace the view with a SP?

Thanks - works fine. For some reason I thought it should be more complex!

Thanks - If it wasn't done that way (the last restore was done WITH RECOVERY) is there a way to stop it?

I don't think it can be restarted without stopping...

The restore was initiated through EM. What I need to know is if it will complete eventually or if I have to intercede.

If I have to stop the LOADING process...