Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql dmv to capture updates

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DATABASE')
AND OBJECT_ID=OBJECT_ID('TABLE')
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #dmv #capture #updates
ADD COMMENT
Topic
Name
6+1 =