May 18, 2009 at 1:01 am
If i delete a records in table ... we can retrieve that using
trigger and Deleted objects..
With out Trigger and Deleted Objects ,
can we fetch the deleted records..Is there any way?
May 18, 2009 at 2:01 am
viswa (5/18/2009)
With out Trigger and Deleted Objects ,can we fetch the deleted records..Is there any way?
Not in SQL 2000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2009 at 3:04 am
IN 2005 WE HAVE OR NOT? TELL ME A WAY..
May 18, 2009 at 5:50 am
viswa (5/18/2009)
IN 2005 WE HAVE OR NOT? TELL ME A WAY..
Don't shout at me.
You posted in the 2000 forums, hence I answered for SQL 2000.
In 2005 you can use the output clause. See books online for full details.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply