April 17, 2008 at 8:57 am
I got script from this helpfull site befor two years for crating trace file and log trace for my database
and it's work fine,when we migrate to sql server 2005 i take the same script for this trace and he create it successfully but the problem when i try to open this file for example today file:
SQL-Server1 SQL Trace20080417000000847.trc
I got the following message:
Sql server profiler :failed to open a file ,access denied.
old files created by sql server 2000 ,i can open it until now but the file created after migrate to sql 2005 ,i got that message above.
April 17, 2008 at 1:20 pm
It indicates that you have not stopped trace and trying to copy file. To verify this run following query
select * from fn_trace_getinfo(default)
you need to stop trace before you copy file.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 18, 2008 at 12:43 am
Mohan is probably true.....stress brings in silly mistakes.....relax.....you know a lot and no one is going to kill you for a mistake....leave you seat and have a stroll every hour.....it has helped me a lot....
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
April 18, 2008 at 12:48 am
What are you trying to open it with? SQL 2000's profiler won't open a trace file created with SQL 2005's profiler or server-side trace commands.
I tested and the error I got was :Failed to open a file
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2008 at 11:54 pm
Trace_id Property Value
112
12C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_22.trc
1320
14NULL
151
212
22F:\Microsoft SQL Server\MSSQL\Audit\SQL-Server1 SQLTrace20080421000000790.trc
23500
24NULL
251
Actually i am creating from sql server 2005 and trying to open it from sql server profile.
What do you mean bt stoping and how?
April 21, 2008 at 12:40 am
If the trace is still running, yuo won't be able to open the file. You'll have to stop the trace, or pause it and copy the trace file elsewhere, to be able to open the trace in profiler.
To stop or pause the trace, you need the sp_trace_setstatus proc. Param details are in books online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2008 at 1:58 am
I am trying to open files before two days which already created and stoped.
I don't know why i can't open it i am not talking with current one.
June 26, 2008 at 8:43 am
I am facing the same problem. Unable to open trace files after upgrading from 2000 to 2005.
Any help is appreciated.
Thanks,
Kjain
October 20, 2008 at 11:46 pm
I created a trace file in sql server 2008 using
[font="Tahoma"]sp_trace_setstatus @traceid , 1 [/font]
after i performed my opearations i stopped using
[font="Tahoma"]sp_trace_setstatus @traceid , 0 [/font]
and finally Closed the my trace and deletes its definition from the server using
[font="Tahoma"]sp_trace_setstatus @traceid , 2.[/font]
When i try to open my trace file i am getting "File can't be open" .
October 21, 2008 at 12:15 am
If i open my trace file using sql server profiler it is opening and showing the trace but if i try to open my trace file by double clicking , it is giving me the error "File can't be opened".
October 13, 2010 at 1:46 pm
still can't open even if I stopped the trace.
October 13, 2010 at 1:49 pm
Can you copy trace file to some where else? I have seen permission issue with trace file and gets resolved after replacing permission with inheritable permission manually. But this issue I have see with trace file created on NAS device. Where u are creating your trace file? Another important point, Please post Group or userNames has permission on file. You can list that thru Security tab in properties of file.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply