Re: How work Profiler.

From: BP Margolin (bpmargo@attglobal.net)
Date: 04/10/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 10 Apr 2003 01:33:09 -0400

Please ALWAYS post which version of SQL Server you are using.

In SQL Server 2000, only members of the SysAdmin role are permitted to execute the Profiler utility. Other than modifying the system stored procedures that are used by the Profiler utility, there is, to the best of my knowledge, no alternative.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Юрий Беляев" <belyaev@telecombank.spb.ru> wrote in message news:O61vI#x$CHA.2208@TK2MSFTNGP12.phx.gbl...
> Good time everybody!
>
> Can you help me.
>
> What stored procedures must have grant access for SQL Profiler work
> Propperly?
> I have been working as simple user, not system Administrator.
>
>

Relevant Pages

  • Re: Object Access?
    ... SQL Server does not track this info. ... run Profiler to see what is going on. ... > they are also referenced in quite a few stored procedures and do actually ... > still redundant or obsolete. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: stress by profiler ?
    ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
    (microsoft.public.sqlserver.server)
Loading