Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Triggers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-09 : 18:13:47
Uri Dimant writes "Hello! I visited on this site and i am very glad. I have got so much good informations.
Now is my question
I have database(A) and compared this (A) to database(B)
I want to keep in (B) all data that was deleted from (A) in order to i can return to users data instead of backup. I meen someone sad " by mistake i deleted important data " and i instead of fill
my backup i shall give him this data from database(B)

How to write trigger that will do it ? please ,give me example of code.
Than kyou very much. Sorry for my english. We are waiting for your answer"
   

- Advertisement -