Need to automatically add a server role after create login

• random_name

  SSC Veteran

  Points: 275

  More actions

  February 24, 2014 at 11:37 am

  #288499

  I have a need to automatically add a server role after any login is created. The idea so far is to make an all server trigger for CREATE_LOGIN. However, I can't find examples of this being done. Is it possible? And any hints?

• JustMarie

  SSCertifiable

  Points: 7771

  More actions

  February 24, 2014 at 1:58 pm

  #1691712

  Please don't cross post.

  Put replies in this post:

  http://www.sqlservercentral.com/Forums/Topic1544683-392-1.aspx