开发者

'Statement' Attribute in SQl Server Auditing Log File

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜