Is there any way to log/monitor the recent select queries executed by users by which we can get the query, user and time related details In the ANSI mode.
i have checked the dbc.QryLog, but it works only for BTEQ mode.
Is there any way of logging select statements in ANSI Mode.
Which version are you on?
On TD 15 you can do:
SELECT * FROM Dbc.DBQLogTbl WHERE TxnMode = 'ANSI';
TD14 Dbc.DBQLogTbl has no TxnMode column, but the content is stored in column "ExtraField21":
SELECT * FROM Dbc.DBQLogTbl WHERE ExtraField21 = 'ANSI';