using fn_trace_gettable on trace files where the path contains aspace.

[nadabadan]

Hi,
Is there a way to read a trace file with fn_trace_gettab le if
that trace file resides in a path that contains a space? For example,
test.trc is accessible with fn_trace_gettab le if it resides in c:
\traces\, but throws an error if the trace file is in c:\my traces\.
Thanks.

-Nada

[Erland Sommarskog]

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

nadabadan (nadabadan@gmai l.com) writes:

Is there a way to read a trace file with fn_trace_gettab le if
that trace file resides in a path that contains a space? For example,
test.trc is accessible with fn_trace_gettab le 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_gettab le('C:\Temp\pro gram files\flexkid'' s\doublefeature .trc', default)

and it ran without a problem.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

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