How can we help you today? How can we help you today?

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

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.

mdullni1
0

Comments

1 comment

Sort by
  • 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.
    Jessica R
    0

Add comment

Please sign in to leave a comment.