Does anyone know the Transact SQL command for SQL Server 6.5 to determine the last time a table was accessed by a user? I have several tables on an old server that no one knows if the tables are being used or not. The system is running on 6.5 so it doesn't have the GUI interface. Thanks so much!
I don’t know of a way to get the last time, but you can use SQL Trace to find the next time. SQL Trace is like SQL Profiler, but shipped with SQL 6.5 (and some older versions). You can trace the activity of the database to determine the use.