Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    64

    Question Unanswered: Getting the full text of a running query?

    Hello!

    There is a long-running query on the server, and I'd very much like to get the full text of it.

    I vaguely remember there being an SP, that would do that -- can any one, please help?

    Something like:

    sp_text SPID

    ? Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    dbcc sqltext(spid) will give you a portion of the query (sometimes the whole thing, it depends).

    Better alternatives on ASE 12.5.0.3 or later is to enable the MDA tables (see http://www.sypron.nl) and get this information from master..monProcessSQLText.

    Michael

Posting Permissions

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