Grant a sql login to run SQL Profiler

• roja.hafezi

  SSC-Addicted

  Points: 474

  More actions

  January 5, 2009 at 4:11 am

  #203614

  Is there a way to grant a SQL Server 2000 login permissions to run the SQL Server Profiler without granting the login the Server Role of “sysadmin”?

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 5, 2009 at 11:04 am

  #921314

  Only in 2005+ (ALTER TRACE).

  SQL Server 2000 requires SA to run Profiler.

  
  * Noel

• roja.hafezi

  SSC-Addicted

  Points: 474

  More actions

  January 9, 2009 at 3:14 am

  #924004

  Tnx !

  Unfortunately,it seams that i cant do anything...