Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: Dbcc Inputbuffer

    Hi folks.
    DBCC INPUTBUFFER(79)
    the statement returned is too short, not full. Can i get full STATEMENT that is sent by the user.

    Howdy!
    Last edited by thebeginner; 10-15-04 at 11:21.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you are using sp3a see "What's New" in the release notes. Otherwise, no.

    -PatP

  3. #3
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    Hi Pat, thanx.
    select serverproperty('productlevel')
    returns SP3.
    There are BOOKSONLINE in the programs group only. Where to find the release notes.


    Howdy!

  4. #4
    Join Date
    Dec 2003
    Posts
    22

    Try this

    There is a new function in SP3 called fn_get_sql.

    Here is an article:

    http://www.novicksoftware.com/UDFofW...fn_get_sql.htm

    HTH,
    Roby2222

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you check the release notes for sp3a, you'll find a reference to fn_get_sql that ought to solve your problem.

    -PatP

  6. #6
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    Thanx all.
    But there's a problem.
    i can get the STATEMENT only for SPIDs that r currently running. Not for those which have status SLEEPING.
    DBCC INPUTBUFFER returns the last statment for SLEEPING connections but ::fn_get_sql doesn't.

    eg. if i open QA , execute STATEMENT and don't disconnect, i can get the text from DBCCINPUTBUFFER but not from the function.


    Howdy!

Posting Permissions

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