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, 5860🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...