Logging "On Delete Cascade"

[bchoi@ueic.com]

Hi. I am trying to log (Not SQL Transaction log) all deleted rows
into a custome log file after performing "cascade delete".
I couldn't find any reference for this in SQL manual or News group.
Byung Choi

[Erland Sommarskog]

Re: Logging "On Delete Cascade"

(bchoi@ueic.com ) writes:[color=blue]
> Hi. I am trying to log (Not SQL Transaction log) all deleted rows
> into a custome log file after performing "cascade delete".
> I couldn't find any reference for this in SQL manual or News group.[/color]

You would do this from a trigger, getting the deleted rows from the
virtual table "deleted" .


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[metalic]

Re: Logging "On Delete Cascade"

Thanks Erland.

[metalic]

Re: Logging "On Delete Cascade"

Thanks Erland.