By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,362 Members | 1,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,362 IT Pros & Developers. It's quick & easy.

using fn_trace_gettable on trace files where the path contains aspace.

P: n/a
Hi,
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\.
Thanks.

-Nada
Mar 19 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nadabadan (na*******@gmail.com) 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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 19 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.