setupadmin Archives -

3 Oct, 2022

T-SQL script to get list of logins having Sysadmin permission 0 (0)

MSSQL, T-SQL Scripts bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, setupadmin, SQL server, sysadmin, TSQL

Below query can be used to check Sysadmin Server role in SQL Server.

select @@servername as Server,sp.name as LoginName,
type_desc as LoginType
from sys.server_principals sp
inner join sys.syslogins sl
on sp.sid=sl.sid
where Sl.sysadmin=1

Sample Output:

… Read the rest

29 Sep, 2022

SQL Server: T-SQL script to get list of logins with server roles 0 (0)

MSSQL, T-SQL Scripts bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, SQL Server role, sysadmin

Below query can be used to get SQL Server logins with server role in SQL Server.

SELECT @@servername as Server, sp.name Login_Name
,Account_Type = CASE sp.type_desc
WHEN 'Windows_Group'
THEN 'Windows Group'
WHEN 'WINDOWS_LOGIN'
THEN 'Windows Login'
ELSE 'SQL Login'
END

… Read the rest

23 Sep, 2022

T-SQL query to get list of logins with bulkadmin role in SQL Server 0 (0)

MSSQL, T-SQL Scripts bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, ServerRole, setupadmin, SQL server, sysadmin, TSQL

Below query can be used to check bulkadmin server role in SQL Server.

select @@servername as Server,sp.name as LoginName,
type_desc as LoginType
from sys.server_principals sp
inner join sys.syslogins sl
on sp.sid=sl.sid
where Sl.bulkadmin=1

Sample Output:

… Read the rest

Tag Archives: setupadmin

T-SQL script to get list of logins having Sysadmin permission 0 (0)

SQL Server: T-SQL script to get list of logins with server roles 0 (0)

T-SQL query to get list of logins with bulkadmin role in SQL Server 0 (0)