Re: using fn_trace_gettable on trace files where the path contains a space.

nadabadan (nadabadan@xxxxxxxxx) writes:
Is there a way to read a trace file with fn_trace_gettable if
that trace file resides in a path that contains a space? For example,
test.trc is accessible with fn_trace_gettable if it resides in c:
\traces\, but throws an error if the trace file is in c:\my traces\.

I tested this on SQL 2005 and Vista x64:

select * from fn_trace_gettable('C:\Temp\program files\flexkid''s\doublefeature.trc', default)

and it ran without a problem.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: run Profiler on a specific SP/Query/Function
    ... systems running on the server, for which the Application name isn't set ... Note that you don't have to have a single trace file. ... Reading about the sp_trace proceures in Books Online gives you more ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Store Procedure - Profile
    ... There is a documented function in SQL Server 2000 that does ... Check fn_trace_gettable in books online. ... an example of loading the trace file into a table in the ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server log file show login succeeded for use sa more than 1000 times
    ... I don't think it's a virus attack, since it only appears in case of client ... Meanwhile I've studied the trace file and it appears that there ... >> I also investigated the SQL Server log files and I found it very strange ... > SQL Server to Windows Only mode as a test and listen for who screams? ...
    (microsoft.public.sqlserver.programming)
  • Re: Setting up Trace in SQL
    ... SQL Server MVP ... "Audrey L" wrote in message ... > trace file 'TraceA.trc' already exists in the directory. ...
    (microsoft.public.sqlserver.security)
  • Re: can we change the file size that c2 creates a new trc file at ?
    ... As far as I know we cant change the trace file size after enabling C2 audit. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
Loading