creating trigger frustration

[ski2sun]

I am trying to do a simple trigger to show the update, insert, delete history in the table 'wplog'. Why am i getting syntax error on such small stateement, its literally from msdn site...please help...please provide simple answer...newbie with this Ent Mgr thanks

CREATE TRIGGER [histlog] ON
[john].[WPLog]
FOR INSERT, UPDATE, DELETE

I am getting 'incorrect syntax near 'DELETE', error 170

 

[tlbroadbent]

What code follows the word delete? You need to post more of the trigger. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ski2sun]

how would this work if I just do insert/update...can you provide me with proper syntax...in its simplest form....
thanks. I can work the delete later...thanks...

 

[tlbroadbent]

You have the proper syntax for the beginning of the trigger. What we need to know is what you have after DELETE so we can determine the reason for the error. You can find the correct syntax in SQL BOL. Please refer to the manual if you need syntax help. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm