What are the challenges you face when working across database platforms? Take the survey
Options

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.

Answers

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.