Post reply

Sql Server Profiler 2005

  • April 17, 2008 at 8:57 am

    #124872

    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

    #803974

    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

    #804116

    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

    #804118

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 20, 2008 at 11:54 pm

    #804760

    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

    #804766

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 22, 2008 at 1:58 am

    #805331

    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

    #834729

    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

    #887427

    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

    #887432

    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

    #1236486

    still can't open even if I stopped the trace.

  • October 13, 2010 at 1:49 pm

    #1236488

    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