Post reply

'APPEND' is not a recognized option

  • August 15, 2008 at 1:15 pm

    #192495

    Hi,

    When I try to modify a trigger that I have made in SSMS for a table I get the following error:

    'APPEND' is not a recognized option.

    The line where the error occurs looks as follows:

    ALTER trigger tI_myTable on dbo.myTable for INSERT WITH APPEND as

    Not sure what to do...

    icekube12jr

  • August 15, 2008 at 1:40 pm

    #858951

    Alter trigger ... with append was deprecated in SQL 2000 and removed in SQL 2005.

    What are you trying to do?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 15, 2008 at 1:54 pm

    #858961

    Thanks for the quick reply! I removed the WITH APPEND and it worked dandy.

    I was trying to rename the table reference in the trigger to correspond to a table I just renamed in the database.

    icekube12jr

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply