Security mode?

• cwoody

  Newbie

  Points: 9

  More actions

  May 3, 2002 at 6:56 pm

  #357530

  What is the T-Sql statement that will show me which security mode is being used? I know how to find it using Enterprise Manager, but I need the T-SQL statement. Thanks!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 3, 2002 at 7:12 pm

  #428452

  Try this:

  xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel'

  Andy

  Andy
  Connect with me on LinkedIn