logging audit events and diable adhoc queries

• lara31

  SSCommitted

  Points: 1802

  More actions

  March 10, 2005 at 11:48 am

  #109635

  how does one disable adhoc queries, and enable logging audit events.

  [font="Comic Sans MS"][/font]It is what it is.

• March 14, 2005 at 8:00 am

  This was removed by the editor as SPAM

• DBAEngg

  Old Hand

  Points: 394

  More actions

  March 16, 2005 at 2:09 pm

  #547387

  1. You can select the option "Disallow adhoc queries" option provided by ODBC provider

  and for

  2. logging audit : go to

  http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

   

• lara31

  SSCommitted

  Points: 1802

  More actions

  March 17, 2005 at 7:50 am

  #547536

  Thanks a lot much aprreciated

  [font="Comic Sans MS"][/font]It is what it is.