Post reply

Super-long-running query?

  • July 30, 2008 at 10:01 am

    #850651

    GilaMonster (7/30/2008)

    I doubt it. Openrowset is a function to pull data into SQL in a table format. The default trace runs to disk.

    I've never seen this on my servers and I do monitor the query stats for long running queries. Never seen the default trace appear.

    Hmm. So this query is almost certainly from someone saving a trace to a table on the server?

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply