Re: SQL 7 Traces
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/21/04
- Next message: vishal subramaniam: "RE: help on a query with parameters"
- Previous message: AA: "SP1 does not work"
- In reply to: Greg Linwood: "Re: SQL 7 Traces"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 10:48:38 +0200
I just like to add that there might be some errors in SQL7 BOL. I recall, when writing the Profiler chapter
for Unleashed", I was surprised by that there were still errors in BOL after release of SQL 7. Nothing major
enough that you couldn't figure out how it was supposed to work. Perhaps this has been fixes in some later
build of BOL 7, or perhaps I just might have too many drinks since that time and remember incorrectly.
Profiler 2K can generate the xp calls for a defined trace in 7 format. Might be useful.
Or perhaps just be prepared if instructions from BOL 7 doesn't seem to work, so you can do some search on
Google etc.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Greg Linwood" <g_linwoodQhotmail.com> wrote in message news:OyGkr21JEHA.2456@TK2MSFTNGP12.phx.gbl... > Hi Greg. > > With SQL 7, you can simply use the SQL Profiler to trace the server. SQL > Profiler is a GUI tool that hooks into server events inside SQL Server. > There are server side services that can run without the GUI which are more > efficient and particularly convenient for admin purposes (can be scheduled > etc). > > To see what traces are running: > use master > exec xp_trace_enumqueuehandles gives you all current trace queues (whether > Profiler is attached to them or not) > > To stop server side traces you'd use a combination of the > xp_trace_enumqueuehandles and xp_trace_destroyqueue system extended stored > procedures. These are written up in SQL 7.0 Books Online so I suggest you > read up on them there.. > > HTH > > Regards, > Greg Linwood > SQL Server MVP > > "Greg" <anonymous@discussions.microsoft.com> wrote in message > news:AAB5C58A-BBB1-42D7-8DD5-A4B76E820131@microsoft.com... > > Can someone tell me how to do a server side trace in SQL 7? > > How to see what traces are running? > > How to stop them? > > Etc..... > >
- Next message: vishal subramaniam: "RE: help on a query with parameters"
- Previous message: AA: "SP1 does not work"
- In reply to: Greg Linwood: "Re: SQL 7 Traces"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
