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.
Â
2016-10-20, 3551👍, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...