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)
 Strange Behaviour of active trace file in SQL 2000

Author  Topic 

ShivaniSuri
Starting Member

4 Posts

Posted - 2009-02-03 : 01:03:46
Hi,

When I try to retrieve the records of active trace file in SQL Server 2000 with following query:
SELECT * FROM ::fn_trace_gettable('C:\trace\server.trc', default)

I got exception which says that " Server encountered an error.... "

Can you pls tell me is there any way/query to read the records of active trace file in SQL Server 2000?

Thanks in advance,
Shivani Suri

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-03 : 10:34:55
http://msdn.microsoft.com/en-us/library/aa258856(SQL.80).aspx
Go to Top of Page
   

- Advertisement -