Why does format fail on database trigger when RENAME is one of the FOR parameters?

mdullni1

When I try to format a trigger with this:

ALTER TRIGGER triggername

ON DATABASE

FOR DDL_FUNCTION_EVENTS, DDL_PROCEDURE_EVENTS, DDL_TABLE_VIEW_EVENTS, DDL_TRIGGER_EVENTS, ALTER_USER, CREATE_USER, DROP_USER, CREATE_ROLE, DROP_ROLE, CREATE_SCHEMA, ALTER_SCHEMA, RENAME

It fails on the RENAME event.  I have to comment that event out to format my code, and then uncomment it to create/alter the trigger.

Jessica R

Hi and thanks for your post!

I'm afraid this error comes from the Microsoft parser we use, which unfortunately doesn't recognize RENAME. Very sorry to say that there's not much we can do from our side, we will need to wait until Microsoft resolves this.