Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    32

    Unanswered: Sql server 2005 Profiler

    Dear friends,
    I got script for creation trace file on server drive.
    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.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is the file still open, and being written to?

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    exec sp_trace_setstatus <trace_id>, 0 --stops the specified trace
    exec sp_trace_setstatus <trace_id>, 2 --closes the trace file generated by the specified trace
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Sep 2005
    Posts
    161
    Robert, did you have to look that up, or are you are you human BOL?

    Quote Originally Posted by rdjabarov
    exec sp_trace_setstatus <trace_id>, 0 --stops the specified trace
    exec sp_trace_setstatus <trace_id>, 2 --closes the trace file generated by the specified trace

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I confused them so many times (which one to issue first), that I had to memorize them
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •