RUN SQL Profiler with non sysadmin role in SQL Server 2000

Hi,

Is it possible to RUN SQL Profiler with non sysadmin role in SQL Server 2000?
Is it possible to include the GRANT ALTER TRACE function to SQL Server 2000?
David Chai
davidch@.avanade.com

Hi David,

It's NOT possible to use SQL profiler with non-admin role in SQL Server2000, NOR can you use "Grant Alter Trace" to grant a non-admin an access to run profiler in SQLServer 2000.

This feature is new in SQLServer 2005.

Please let me know if you have any questions.

thanks,

Allen