How can I check/verify the last login activity of a particular user in the SQL Server 7.0 environment? I want to identify which login account is still active and remove all inactive IDs. Is it also possible to set an inactivity status for login accounts that will automatically remove inactive IDs, say 2 months?
Thanks in advance.