SQL Profiler

• Nenad Božovic

  Grasshopper

  Points: 15

  More actions

  November 28, 2005 at 6:53 am

  #92313

  Can I use SQL Profiler even if I'm not memeber of SysAdmin server role?

• peterhe

  SSChampion

  Points: 11469

  More actions

  November 29, 2005 at 7:15 am

  #606405

  Yes. In SQL 2k5, you can use sql profiler if you have ALTER TRACE permission.

• Bill Scott

  SSCrazy

  Points: 2338

  More actions

  November 29, 2005 at 10:13 am

  #606466

  is there a way to do it with SQL 2000?

• peterhe

  SSChampion

  Points: 11469

  More actions

  November 30, 2005 at 7:42 am

  #606732

  As far as I know, you must be a member of sysadmin to use profiler in SQL 2000.