Trouble in ::fn_trace_gettable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Trouble in ::fn_trace_gettable

Author

Topic

anilinsqlteam
Starting Member

9 Posts

Posted - 2006-11-20 : 04:03:03

Dear All,
I use "sp_trace_create" to create a trace in the file "C:\TestTrace".
Then used "sp_trace_setevent" to Set the events and data to collect.
And then by using

EXEC sp_trace_setstatus @TraceID, 1

I started the trace. Now I want to get the values in tht trace file and for that I am using the querry

SELECT * FROM ::fn_trace_gettable('C:\TestTrace.trc', 0).

Now the problem after some events occure for which I have set the trace I am not able to get the querry run. It says the file is in use or not in correct format...

And I saw the file size is also 0. But after I end the trace by using

EXEC sp_trace_setstatus @TraceID, 0
EXEC sp_trace_setstatus @TraceID, 2

then only I was able to run the above querry. So I want to know is it poss

Regards
Anil

Regards
Anil

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-20 : 04:05:12

Please don't crosspost:

Duplicate post here: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75186[/url]

Harsh Athalye
India.
"Nothing is Impossible"

anilinsqlteam
Starting Member

9 Posts

Posted - 2006-11-20 : 04:59:26

Sorry for that
Deleted the duplicate topic

Regards
Anil

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources