SQL profiler and index tuning wizard permissions

From: Martin de vroom (martindevroom_at_hotmail.com)
Date: 06/21/03 

Date: Sat, 21 Jun 2003 17:13:29 +1200

Hi,

I wish to ask about the permissions needed to run either sql profiler and
index tuning wizard.

I have always been under the impression that in order to run both of these
utilities that you needed to be a member of sysadmins.

however I recently read an article saying that sql profiler can be run by
anybody who has execute permission on all stored procedures for it.

is this true?

I found a list of extended sp's used by profiler in books online but am no
so sure that this ia a full listing.

I can't find any reference to any kind of stored procedures used by index
tuning wizard so I guess people who run this must have to be members of
sysadmins.

can anybody please tell me if my assumptions on the above points are correct
or not and point me to articles ect that might clarify this point.

cheers

martin.

Relevant Pages

  • Truncating Parameters in VS.Net 2003
    ... I have some stored procedures that accept a text parameter ... Right Click on sproc in VS.Net Server Explorer. ... but SQL Profiler shows truncated parameter. ...
    (microsoft.public.vsnet.ide)
  • Re: **follow "login" activities**
    ... SQL Profiler can help you do this. ... You can also use some third party tools like Lumigent Explorer which let you ... read the contents of a transaction log from where you can get this ... > look in the Master dB at the stored procedures and extended procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: How does OWSSVR.dll call proc_FetchDocForHttpGet stored procedure?
    ... as the stored procedures could be called from other ... In any case, I appreciate your advice! ... So if you want to research the dll internal on how to reach the store procedure, I'd suggest you can use SQL profiler to monitor the SQL ...
    (microsoft.public.sharepoint.portalserver.development)
  • Capturing Stored Procedure, Table and View info with SQL Profiler
    ... I have just started using SQL 2000 SQL profiler to capture server information ... on Stored Procedures. ... I need some help in understanding how to use this tool ...
    (microsoft.public.sqlserver.server)
  • RE: Which indexes are used?
    ... Use SQL Profiler, and also the Index Tuning Wizard if you want a ... Rgds, ... "Malin Davidsson" wrote: ...
    (microsoft.public.sqlserver.programming)