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, 4977🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...