How to log the count of deleted records in table in sql server?
Posted on 2014-07-18
Every day sql server job runs that calls the storedproocedure who delete the last 3 years data. I want the StoredProcedure also create a log table who stores the deleted data information(Comma delimited list of all ids of deleted records, count of all deleted items, date when the items deleted)?
How to create a log table in storedprocedure