Forum Replies Created

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

  • RE: SQL server Trigger for Granting server role

    Hi,

    I tried creating the tigger with this code.

    I got the below error

    Msg 1082, Level 15, State 1, Procedure NameOfTrigger, Line 9

    "ADD_SERVER_ROLE_MEMBER" does not support synchronous trigger registration.

    April 27, 2012 at 12:26 am

    #1480199

  • RE: SQL server Trigger for Granting server role

    Thanks for the very quick responce.

    I tried giving ADD_SERVER_ROLE_MEMBER, but i got the below error.

    Msg 1082, Level 15, State 1, Procedure TR_DDL_AUDIT_LOGIN, Line 56

    "ADD_SERVER_ROLE_MEMBER" does not support synchronous trigger registration....

    April 26, 2012 at 8:35 am

    #1479792

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