help on ODS!!!

• raullen

  SSC Journeyman

  Points: 75

  More actions

  May 18, 2005 at 10:01 pm

  #89007

  hi i need your help!!!

  now i am in a project called sqlserver IDS and my work is to capture sql query and intercept them on the server.

  maybe i should do something from ODS programme but i really

  need to know some details .so help me.

  thanks/....

• Ford Fairlane

  SSCertifiable

  Points: 7664

  More actions

  May 18, 2005 at 10:13 pm

  #559769

  If you need to capture queries, use profiler and save it to either a file or a table and then you can analyz it when your ready to

  Hope this helps...

  Ford Fairlane
  Rock and Roll Detective

  

• Rob Sanguin

  SSChasing Mays

  Points: 610

  More actions

  May 24, 2005 at 3:05 am

  #560698

  You could try looking at the sp_addtrace and related system s procs.

  These will let you save info on queries, in a similar way to profiler does but more flexibly, to a file or table for later perusal!