Login auditing

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  January 31, 2005 at 3:44 am

  #84686

  Can you change the audit level of logins on SQL Server without the need to stop and restart the SQL Server Service?

  Thanks in advance

   

  Carl

   

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 31, 2005 at 6:39 am

  #539721

  not that I'm aware of.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• tjp8

  SSCommitted

  Points: 1989

  More actions

  January 31, 2005 at 7:48 am

  #539732

  According to all of the documentation I have read, changing the audit level always requires a instance restart for it to take effect. 

  TJP8