You may use the T-SQL code below to find the last logon dates for the SQL accounts. use master; set nocount on -- find users, last logon time, and disabled state declare @users_login_time table (…

The T-SQL query below will list the users configured within the database, and the permissions which these users have. SELECT [UserType] = CASE princ.[type] WHEN 'S' THEN 'SQL User' WHEN 'U' THEN…