SQL Profile
From: Peter the Spate (anonymous_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Jéjé: "Re: memory usage and configuration..."
- Previous message: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- In reply to: pohkeat: "SQL Profile"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 08:25:28 -0700
Try the event classes RPC:Completed and SQL:StmtCompleted.
Peter
MCDBA
>-----Original Message-----
>2 SQL2000 Std Server - Server 1, Server 2.
>A 3rd party application sits on Server2, that does
polling and
>update/inserts of data into Server1
>
>I wish to run SQL Profiler on Server1 to investigate what
are the tables,
>procedures called or executed by this 3rd party app.
>
>I tried setting up a trace for 1hr on Server1 that
filters only the events
>created by the application's name. However nothing is
captured.
>
>Not familiar with SQL Profiler myself, can anyone advise
what are events to
>capture that will give me what I want to know ?
>
>
>tks.
>
>
>
>.
>
- Next message: Jéjé: "Re: memory usage and configuration..."
- Previous message: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- In reply to: pohkeat: "SQL Profile"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
