Jump to content

Unable To Test For When A Table Was Last Updated


ready2drum
 Share

Recommended Posts

While trying to determine when a specific table was last updated, an error message appeared (using SQL Server Management Studio).Error: Msg 208, Level 16, State 1, Line 1Invalid object name 'sys.dm_db_index_usage_stats'.See code below:

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*FROM sys.dm_db_index_usage_statsWHERE database_id = DB_ID('MasteryNet')AND OBJECT_ID=OBJECT_ID('LAST_RECORDS'

Not sure what else to try to get the code to run without errors....any suggestions would be a great help!Thanks!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...