Collections:
sys.server_principals - Listing All Login Names in SQL Server
How To List All Login Names on the Server in SQL Server?
✍: FYIcenter.com
If you want to see a list of all login names defined on the server, you can use the system view, sys.server_principals as shown in this tutorial exercise:
-- Login with sa SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type = 'S'; GO name sid type type_desc -------- ----------------------------------- ---- --------- sa 0x01 S SQL_LOGIN FYI_DBA 0x348AF32B3B58CB40B67A5F5B7086B96E S SQL_LOGIN Fyi_Login 0x5EB8701EAEBAA74F86FCF5BD8E37B8C5 S SQL_LOGIN
So you have two login names on the server at this moment.
⇒ "ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
⇐ Verifying a Login Name with SQLCMD Tool in SQL Server
2016-10-20, 5119🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...