查看sql数据库操作日志的方法步骤:
1、用windows身份验证登陆数据库,点击【连接】;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/562c11dfa9ec8a136369445ff303918fa0ecc019?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、展开数据库服务器下面的【管理】【SQL Server日志】;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d009b3de9c82d158b2c94a0e840a19d8bd3e42c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、双击【当前】可以打开【日志文件查看器】里面有所有的运行日志;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0824ab18972bd4078265c0427f899e510eb309ea?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击任意一行,可以看见具体的信息,错误原因和时间;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b36e70e0852a7cc7cd98c109df4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、勾选相应的复选框,可以筛选查看相应的日志内容;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da97739126dbd96defc198618377ae2f2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击【筛选】还可以详细筛选日志;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a686c9177f3e67095a9556403fc79f3df9dc55f3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、在【SQL Server日志】上单击右键,选择【视图】【SQL Server和windows日志】可以查看操作系统日志;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b36e7d10852a7cc7cd98c109dc9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、如图所示,就可以查看到操作日志了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43f2225824d791ed21b0ff43b84?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
按以上步骤操作即可以查看操作日志。