UseMaster
SELECTexecquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROMsys.dm_exec_query_stats AS execquery CROSS APPLYsys.dm_exec_sql_text(execquery.sql_handle) AS execsql
wherelast_execution_time > '2017-01-10 02:18:20.670' --start time
and last_execution_time < '2017-01-10 03:18:20.670' --end time
and execsql.text like '%@@identity%' --keyword
ORDERBY execquery.last_execution_time DESC
another solution posted on stackoverflow,
C:\Users\<username>\AppData\Local\Temp, search *.sql
actually, those sql are empty files
本文介绍了一种查询方法,通过SQL语句筛选在指定时间范围内执行且包含特定关键字的所有SQL脚本。该方法利用了系统视图和动态管理视图来获取所需信息。
6362

被折叠的 条评论
为什么被折叠?



