Hi All experts,
i am VFP developer and newly SQL server . i want to create stored procedure or triggers ( which is best and practice,easy) for tracking user activities on tables ( add delete update ) . i am doing it in VFP just a funciton in storec procedure ( named myaudit ) and i put myaudit("I") myaudit("U") myaudit("D") to the dbf tables table-triggers section at design time. that's enough my needs.

So i want to do the same thing on sql server . i dont need professional solution just track these activities and keep its on the table such audist.

How can i do this ?
any help will be very appreciated

TIA