This is not really a Strataframe issue but would welcome any comments , as most users around here seem to use SqlSErver. I have been playing around with SQLSERVER over last few months and am concerned , that when I have live data, I will not be able to restore transations.

Say for instance, I do the following in Management studio:

Delete From Mytable where 1=1, amd the table was 600,000 transactions...takes a few seconds to remove records but would take a long time to re key !!

In VFP. I'd just do a Recall all and problem sorted.

I know there is a Log Table which holds transactions, but there does not seem to be any way from within Sql Server to access this table..... seems stange to me but there you go.



What do you guys use ,to recover from this situation.... I know there are tools out there but an indication of popular/good ones would be useful

Regards,

Gerard