Hi there. I need to develop some kind of trigger that somehow sends all deleted rows to some kind of "recycle bin" to possible recover them and/or anlisys (only if there are a great number of rows deleted, let's suppose more that one ) What I've accomplished so far is a generic trigger that detects how much deleted rows and logs in another table what database and numer of rows. to have some idea there is what I got so far : CREATE TRIGGER Trigger_FOO ON [dbo].[table_foo] FOR DELETE AS BEGIN set nocount on declare @c int select @c = count(*) from deleted if ( @c > 1 ) BEGIN declare @table varchar(100) declare @base varchar(100) declare @delete int select @table = B.name from sysobjects A with(nolock) join sysobjects B with(nolock) on ( a.parent_obj = B.id ) where A.id = @@PROCID set @base = db_name() select @delete = BASEXXX.dbo.FDecide ( @base , @table , @c ) if @delete = 0 ROLLBACK TRANSACTION -- Don't let the delete proceed exec BASEXXX.dbo.spLog @base , @table , @c , @delete END END I'm doing a basic logging right now. (database, table name, count(*) of deleted and what was the function "decision" as to delete the rows or not ). The idea is having the SAME trigger applied to all tables. That's why I get the table name through @@PROCID and sysobjects. I'll be better if I can put some generic trigger to all deletes of all table, but I don't think this is possible. (I already KNOW how to do it for some pre-established specific table) what I wanna do is somewhow ( with dynamic SQL I guess ) is go thru all rows and columns of deleted and sent then to some repository or recycle bin (maybe as a long string of comma delimited values or something like that). I don't figure out yet how to do it generic. And i don't think I can access deleted virtual table from inside synamic SQL (I'll be out of scope ). any ideas? Thanx guys.