InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:26:09 GMT20http://www.sqlservercentral.com/Forums/Topic1412134-392-1.aspxPlease don't cross post. direct all replies here. [url=http://www.sqlservercentral.com/Forums/Topic1412099-392-1.aspx]http://www.sqlservercentral.com/Forums/Topic1412099-392-1.aspx[/url]Mon, 28 Jan 2013 07:48:56 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1412134-392-1.aspxthere is no catch block in your trigger. Is that how you intend it ? If so, don't use the try.Sun, 27 Jan 2013 13:35:46 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1412134-392-1.aspxThis is the first time I am writing a trigger. I am getting the following error message on a sql server 2008 r2 database."Msg 102, Level 15, State 1, Procedure eRPT_Transaction_Audit, Line 15 Incorrect syntax near 'TRY'. I do not know what is wrong can you tell me what is wrong with the following sql:USE DEVGOCREATE TRIGGER [dbo].[eRPT_Transaction_Audit] ON [dbo].[eRPT_Transaction_Tracking] AFTER INSERTASBEGINSET NOCOUNT ON;BEGIN TRY INSERT INTO [dbo].[eRPT_Transaction_Audit] (Package_name, Received_Date, Download_Date, Acknowledge_Date, Response_Docs_Date, Error_Report_Date, FDR_Report_Date, Close_Date, File_Location,Response_Code) SELECT Package_name, Received_Date, Download_Date, Acknowledge_Date, Response_Docs_Date, Error_Report_Date, FDR_Report_Date, Close_Date, File_Location,Response_Code FROM INSERTEDEND TRY ENDGOalso note in the trigger, I am not listing the identity key for the tableSun, 27 Jan 2013 09:13:55 GMTwendy elizabeth