Is there a way to find out when a database was last accessed on SQL Server 2000? By this I mean, had a table read, a stored procedure called etc...
I have a list of databases and I am trying to find out which databases are still needed or not.
I'm not sure
sp_who2.LastBatch
will give me the result I need.
Asked by rhughes
(325 rep)
Jul 15, 2013, 03:06 PM
Last activity: Dec 28, 2023, 11:57 AM
Last activity: Dec 28, 2023, 11:57 AM