T-SQL query to get list of logins with bulkadmin role in SQL Server dbalyfe

23 Sep, 2022

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

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: