SQl Query

Madhava · September 24, 2015, 11:36am

Hi. I need SQL query to get all tables in DB effected in last 15 minutes

djj55 · September 24, 2015, 12:05pm

This is not possible as stated. You can do it if you have tracing on, but it is not straight forward.

khtan · September 25, 2015, 1:30am

As @djj55 stated, the information is not available as it is. You can use SQL Profiler or trace to record all query for the required time frame. Output the result to a staging table and then query from that

viggneshwar · September 25, 2015, 6:59am

DDL Changes can be tracked easily by using SYS.Tables

SELECT * FROM sys.tables
WHERE datediff(minute,modify_date,getdate()) < 16