Undelete

May 18, 2004

I have deleted table in EM
is it any way to get it back ??

Undelete...

Aug 2, 2000

Hi,

I'm using SQL Server 7.0. I've just deleted 38 records from my table. I need to recover them. Is there any way to do this without doing a full restore of the database or is it possible to restore just 1 table.

Thanks,
Darrin

View 1 Replies View Related

Undelete Deleted Recrods From Table

Jan 20, 2004

hello forum

Is there way to undelete deleted records from a table? - For security reasons I need to delete records without removing them out of the database.

In other words: target is to design a procedure to delete records only logical.

I had the idea to use a field, saying record is deleted or not.
This field would control if data is hidden (logical deleted) or not. To undelete a record, only this field would change its state.

But it becomes difficult if you have many FK to logical deleted data.

Is there a better or easier way to do this?

Thanks for you help !!

View 2 Replies View Related