• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/11ee

To view that information, there are 2 primary ways:select * from tempdb.INFORMATION_SCHEMA.C... where table_name like '#MyTempTable%'select * from tempdb.sys.columns where object_id = object_id('tempdb..#mytempt... ......

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/11ec

This query will bring back the last user update to every table in the database you're connected to.use [dbname]goSELECT last_user_update, t.name FROM sys.dm_db_index_usage_stats us JOIN sys.tables t ON t.object_id = us.object_id WHERE database_id = db_id()and cast(last_user_update as date) >= cast('2018-05-09' as date)order by last_user_update desc ......

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/11eY