thanks yep

Thanks Lynn.

I was planning on creating a new snapshot at the end of every day. So I would have historical data. My users want the ability to search the snapshots...

Steve Jones - Editor (12/14/2009)

---

You could use snapshots if you have Enterprise edition, but if you need to restore or something happens you'll lose them.

A better solution would be calculate...

Jeff Moden (12/14/2009)

---

krypto69 (12/14/2009)

---

I have a DB that gets updated throughout the day.

My users need the ability to go back in time and search on data say from the end...

K....I know about those...

was hoping there was something I was missing

Thanks!

I got it, thanks anyhow!

figured it out...thanks guys

I got it

thanks Crosan!

Yes thats' what I'm doing...

Got it, had to drop the MDF/LDF....and reatore..nothing else worked thanks

Tried that already...

Msg 4333, Level 16, State 1, Line 2

The database cannot be recovered because the log was not restored.

Msg 3013, Level 16, State 1, Line 2

RESTORE DATABASE is terminating...

Thought so thanks!!

will that do the 'like' on every column?

Thanks Adiga

Thanks guys...

I needed to delete everything from the SQL2000 instance...including all directories? odd but it worked...

Thanks again..good karma to you all