var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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)