1) In SQL Server 2005 and onwards you can use the sys.dm_db_index_usage_stats data
management view, look at the column last_user_update, you can also see when
the table was last accessed (last_user_seek and last_user_scan - do a MAX on
them).
SELECT
last_user_seek = MAX(last_user_seek),
last_user_scan = MAX(last_user_scan),
last_user_lookup = MAX(last_user_lookup),
last_user_update = MAX(last_user_update)
FROM
sys.dm_db_index_usage_stats
WHERE
[database_id] = DB_ID()
-- if you want to leave out system objects, uncomment the next line:
-- AND OBJECTPROPERTY(object_id, 'IsMsShipped') = 0
2) Rename the database and see if you start getting complaints from users :-)))))
Thank you Uri.
New to SQl Server and am on a learning curve.
Thank you Rajendra.