Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Location
    India
    Posts
    56

    Unanswered: Regarding dbcc sqltext

    Hi,

    I have one query here.I can use dbcc sqltext after 12.0.x versions but i want to know the previous transaction details of a spid in version 11.0.x. Please help me in this regard.



    Thanks
    PVVS Naveen

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Setup auditing
    There will be a performance impact but should help you trace a specific problem then you can disable it again.

    Then to get the sql text for a user
    sp_auditlogin [login_name [, "cmdtext"
    [, "on"|"off"]]]

    Else use other tools like snoop on unix or rebo from ASE 12 to capture the network packets transfered to the sybase server port.

Posting Permissions

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