June 6, 2007 at 3:24 am
- Think of te consequences of auditing this way (data volume)
- Check "create trigger" in BOL
e.g.
create
trigger trg_D_yourtable on yourowner.yourtable
AFTER
DELETE
AS
INSERT INTO yourowner.yourtable_Auditlog
-- column-mapping must be the same !! (or you'll have to state every column)
SELECT *
from deleted -- = object that contains your deleted row(s) data
GO
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 6, 2007 at 4:00 am
Thank you very much for the prompt reply.
I was getting stuck with the insert statement (didnt read BOL properly about the 'deleted' table) so i was inserting from the originating table, but getting around 150 000 records in my audit table!!!
Take care!
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply