SQL Server/T-SQL Tutorial/System Tables Views/sys.syslogins

Query sys.syslogins

69> SELECT name, hasaccess, isntname, isntgroup, isntuser, sysadmin
70> FROM sys.syslogins
71> WHERE LEFT(name, 4) <> "##MS"
72> GO
name                                                                                                                             hasaccess   isntname    isntgroup   isntuser    sysadmin
-------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- -----------
sa                                                                                                                                         1           0           0           0           1
BUILTIN\Administrators                                                                                                                     1           1           1           0           1
NT AUTHORITY\SYSTEM                                                                                                                        1           1           0           1           1
J\SQLServer2005MSSQLUser$J$SQLEXPRESS                                                                                                      1           1           1           0           1
BUILTIN\Users                                                                                                                              1           1           1           0           0
(5 rows affected)
1>
2> IF EXISTS(SELECT * FROM sys.syslogins
3>     WHERE name = N"computername\winlogin1")
4>     DROP LOGIN [computername\winlogin1]
5> GO
1>
2> CREATE LOGIN [computername\winlogin1] FROM WINDOWS
3> GO
Msg 15401, Level 16, State 1, Server J\SQLEXPRESS, Line 2
Windows NT user or group "computername\winlogin1" not found. Check the name again.
1>
2> SELECT name, hasaccess, isntname, isntgroup, isntuser, sysadmin
3> FROM sys.syslogins
4> WHERE LEFT(name, 4) <> "##MS"
5> GO
name                                                                                                                             hasaccess   isntname    isntgroup   isntuser    sysadmin
-------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- -----------
sa                                                                                                                                         1           0           0           0           1
BUILTIN\Administrators                                                                                                                     1           1           1           0           1
NT AUTHORITY\SYSTEM                                                                                                                        1           1           0           1           1
J\SQLServer2005MSSQLUser$J$SQLEXPRESS                                                                                                      1           1           1           0           1
BUILTIN\Users                                                                                                                              1           1           1           0           0
(5 rows affected)
1>