Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    3

    Unanswered: Any method to record all SQLs and stored procedure calls submitted to a Sybase server

    I want to know whether there is any method to record all SQLs and stored procedure calls submitted to a Sybase server.

    It seems to me that there should be a trace flag that allows this. But I could not remember which flag.

    Please advise. Thanks.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You can do it via auditing or the monitoring tables
    The trace flags will truncate some sql but maybe it is good enough for you

    dbcc traceon (11201, 11202, 11203, 11204, 11205, 11206)

    -- 11201 Logs client connect events, disconnect events, and attention events. (global)
    -- 11202 Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text. (global)
    -- 11203 Logs client rpc events. (global)
    -- 11204 Logs all messages routed to client. (global)
    -- 11205 Logs all interaction with remote server. (global)
    -- 11206 Logs file/directory processing steps
    -- 11207 Logs text and image processing. (global)

Posting Permissions

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