SQL Profiler 2000

22 Nov 2005 9:35 AM

David

When i run the SQL Server Profiler 2000 using a non sysadmin fixed role, it
state that only sysadmin allow to perform that function.
In SQL Server 2005 Profiler, sysadmin allow to grant non sysadmin user to
perform the same function via the GRANT ALTER TRACE feature. Is it possible
to integrate this feature on SQL Server 2005 to SQL Server 2000? if not, how
do i tackle this?

22 Nov 2005 10:26 AM

Greg Linwood

No, but this is one of the reasons why I designed SQLBenchmarkPro - it
allows users to run profiler traces gainst SQL 2000 without needing sa
permissions (amongst other things). We're in beta now, but close to
release. You can grab a copy at www.gajsoftware.com if you're interested.

Regards,
Greg Linwood
SQL Server MVP

Show quote

"David" <Da***@discussions.microsoft.com> wrote in message
news:8BC61A88-F9D6-4071-842A-D7EBB1CE055A@microsoft.com...
> When i run the SQL Server Profiler 2000 using a non sysadmin fixed role,
> it
> state that only sysadmin allow to perform that function.
> In SQL Server 2005 Profiler, sysadmin allow to grant non sysadmin user to
> perform the same function via the GRANT ALTER TRACE feature. Is it
> possible
> to integrate this feature on SQL Server 2005 to SQL Server 2000? if not,
> how
> do i tackle this?