Re: Using Profiler to filter update statements on a database table
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/11/04
- Next message: Tibor Karaszi: "Re: SQL Sqerver trace file creation for stored procedure"
- Previous message: Jasper Smith: "Re: IE Script ERROR with EM"
- In reply to: TMR: "Re: Using Profiler to filter update statements on a database table"
- Next in thread: TMR: "Re: Using Profiler to filter update statements on a database table"
- Reply: TMR: "Re: Using Profiler to filter update statements on a database table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 22:36:29 +0100
You need to use the right events in the trace. For instance, Stored
Procedure, SP_StmtStarting.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "TMR" <trajparia@yahoo.com> wrote in message news:B6336042-C68E-4D68-8544-0BA2016C42DE@microsoft.com... > Hi, > I am tryitng to create SQL trace for procedure. I am fairly new to SQL server, have used Oracle in past. I tried creating SQL trace for procedure which in turn does lot of processing and calls other procedures. Trace just genrated one singe timing for the whole procedure combined, I want it for individual statements and want to see the indexes used. > > Can you plase help: > > Thanks, > Trupti
- Next message: Tibor Karaszi: "Re: SQL Sqerver trace file creation for stored procedure"
- Previous message: Jasper Smith: "Re: IE Script ERROR with EM"
- In reply to: TMR: "Re: Using Profiler to filter update statements on a database table"
- Next in thread: TMR: "Re: Using Profiler to filter update statements on a database table"
- Reply: TMR: "Re: Using Profiler to filter update statements on a database table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
