I am in a new location that has no earhtly clue to what databases and logins are being used. In Sybase I would execute the following command and watch it for a few weeks and if the IO and CPU count stay at 0 I would identify those users and/or databases for cleanup. I am pretty rusty with my sql server, been a useless mgr for a while, and am looking for a sql2k equivelant. any help is appreciated.
thanks,
Les
use master
go
EXEC sp_configure 'allow updates to system tables',1
go
update syslogins set totio=0,totcpu=0
go
use master
go
EXEC sp_configure 'allow updates to system tables',0
go