'APPEND' is not a recognized option

icekube12jr

Hi,

When I do a Smart Rename on a table in my database, I get this error:

'APPEND' is not a recognized option.

This happens for every trigger that is to have the renamed table updated. This is the line where I assume the error comes from as it contains the word APPEND:

ALTER trigger dbo.tD_myTable on myTable for DELETE WITH APPEND as

Not sure what to do...

icekube12jr

icekube12jr

It appears that this problem is caused because you cannot use the WITH APPEND clause in an ALTER statement in SSMS 2005. Once I removed all the WITH APPEND clauses, the script ran fine.