开发者

'Statement' Attribute in SQl Server Auditing Log File

开发者 https://www.devze.com 2023-02-17 02:27 出处:网络
Can anyone plz tell me how can i re开发者_如何学JAVAad the value of parameteres in the sql server audit log file\'s statement attribute.

Can anyone plz tell me how can i re开发者_如何学JAVAad the value of parameteres in the sql server audit log file's statement attribute. for example : i fired a query select name from some_table where id='someID'

In log file i get the entry in the statement attribute as Select from [some_table] where [id]=@1

So can someone help me to get the value of this @1???


You can record the queries as they are executed by using trace (with SQL Server profiler for example) and logging the RPC:Completed event.

0

精彩评论

暂无评论...
验证码 换一张
取 消