Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72

    Unanswered: sql profiler cannot trace to table

    The trace is configured to log to a table in any database (tested them all) on the same server. When the trace is run it appears to "prep" for the trace by creating the excel output grid format but it does not begin the trace. After several minutes a simple alert window pops up and says "failed to start new trace" No other error is generated.

    This is the first time that sql profiler has been run on this server.

    BTW, I can run trace to a file so it appears that this is tied to accessing the db to write to the table.

    Addtionally the app currently runs all operations as "sa" (soon to be changed)

    Mike

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check the SQL error log for any information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72
    Originally posted by Satya
    Check the SQL error log for any information.
    error log is clear.

    I had to not use the "." for localhost and use the actual host name. I have alerted the sa and he will look into it further.

Posting Permissions

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