Lynn Pettis (12/16/2009)

---

You need to use dynamic SQL. You can do it directly in the T-SQL job step or as a stored proc executed in a T-SQL job step....

I think the retension policy is going to be one year.

I don't really have access to the individual transactions. I know that sounds odd, but this is a core system for us, they do not want it tampered with directly....

No Jeff,

The balance data is updated throughout the day and is a rolling balance.

Do I don't really have a way..

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...