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:

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.