Unanswered: Get a List of Last date Database access in SQL Server 2000
I had tried on my local server for the getting details who are last date accessed database in sql server 2000.
select b.name as DBName,a.login_time,a.last_batch,a.hostname,a.prog ram_name,a.hostprocess,
from sysprocesses a, sysdatabases b where a.dbid=b.dbid order by a.last_batch desc
Can anyone give me sql script for getting all remote server detail.