Tracing SQL Server activities

From: Amin Sobati (amins_at_morva.net)
Date: 07/25/04 

Date: Sun, 25 Jul 2004 20:22:12 +0430

Hi,
I need to create a trace using sp_trace_create and write its output to a
table like what profiler does. In the syntax of sp_trace_create I see only
@tracefile option that writes to a file. How can I insert them as rows into
a table?
Any help would be greatly appreciated.
Thank,
Amin

Relevant Pages

  • RE: Form questions
    ... You should be getting the following in the profiler when you trace the call. ... If I copy this into Query Analyzer I am prompted to define the variable. ... syntax is correct and the resultant recordset is what I want. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Form questions
    ... You should be getting the following in the profiler when you trace the call. ... If I copy this into Query Analyzer I am prompted to define the variable. ... syntax is correct and the resultant recordset is what I want. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Profiler Bug viewing trace flat file?
    ... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ... declare @TraceID int ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler Bug viewing trace flat file?
    ... exec PostAvailableContractsCache_sp ... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler temp file
    ... Yes you are missing the whole point. ... Trace to a file without running profiler at all. ... shows how to create a script from scratch but if you follow my instructions ...
    (microsoft.public.sqlserver.tools)