When a row is created in [person] I want to trigger a stored procedure to take update another table [userlog] with the contents of a note field that is being inserted to person table.
My goal is to update a user log table with username and description of what that user is doing to the data. I figure triggers would be an easy way to do this but there is not much I can find in help files to show me how to do this. I think I can figure out how to Alter the table to create the trigger. but I dont know how to go about writing the syntaxs for the storedProcedure. Is it anything like PL/SQL?
CREATE PROC foo() AS --declare stuff; BEGIN --do stuuf; END;
???
help please!

