开发者

Can you use the free AnjLab Profiler for SQL Server Express to view the actually SQL command used to access the dababase?

It seems the trace can o开发者_Python百科nly tell you something accessed the database, but not the SQL command.


Yes. It will show up in the TextData column.

As an experiment, run a trace selecting all events and all event columns.


Yes you can show the actual query fired on the database. for this you have to select appropriate events from the events list. To get the exact query select the following events :

  1. SQLStmtCompleted
  2. SPstmtCOmpleted
  3. SQLtransaction
  4. SqlfulltextQuery

Try this.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜