Are there any queries in SQL Server that return all login accounts and information about them? On SQL Server there is a virtual catalog table (a VIEW, or system table) called sys.sql_logins. You can run the above query and the results will return all Login created in SQL Server with information about them.
To retrieve all login accounts in SQL Server, run the following command.
SELECT*
Ma ster.sys.sql_loginsFROM ma
;
VIEW sys.sql_logins includes the columns below
Column Explanation of ten This is ten_dangnhap specified in the CREATE LOGIN command id_uynhem Number value giatri_duynhat The unique value specified in the CREATE LOGIN command typeProxy type:
Description for proxy types:
Compatible in older versions
In older SQL Server versions, you can get all Login information using the SQL Server 2000 system table like sys.syslogins, using the command below.
SELECT *FROM master.s
ys.syslogins;
The system table sys.syslogins (SQL Server 2000) contains the following columns.
Column Explanation giatri_duynhat The unique value specified in the CREATE LOGIN page command does not apply immediately The Date / Time created Login with the CREATE LOGIN command immediately snapnhat Last login date / time with the command ALTER LOGIN accdate Not used totcpu No apply totio Not apply spacelimit Not applicable timelimit Not apply resultlimit Not apply ten This is ten_dangnhap specified in the CREATE LOGIN command. tendb The default database is the default language 0 or 1 default 0 or 1 number 0 or 1 number 0 or 1 number 0 or 1 admins 0 or 1 admin or 0 adminset 0 or 1 admin 0 or 1 adminodia 0 or 1 nguoitaodb 0 or 1 adminbulk 0 or 1 tendangnhap This is ten_dangnhap specified in the CREATE LOGIN command.Previous article: DROP LOGIN command in SQL Server
The following article: CREATE USER command in SQL Server
ncG1vNJzZmismaXArq3KnmWcp51ks6q6w2ajqJ%2BZo3qquoysqKVlo5q%2Ft7HR