How to find users with sysadmin role in SQL Server

The below script can be used to find out the users with sysadmin role in SQL Server.

SELECT SP.name     AS LoginName,
       type_desc   AS LoginType,
       Cast(create_date AS DATE) DateCreated
FROM   sys.server_principals SP
inner join sys.syslogins SL
on SP.sid=SL.sid
WHERE SL.sysadmin=1

2 comments:

  1. kalyaniJune 17, 2020 at 5:56 AM

    Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
    Msbi online training Hyderabad
    Msbi online training India
    Msbi online course
    Msbi training online

    ReplyDelete
  2. laxmicynixitAugust 29, 2022 at 8:24 AM

    nice thanks for sharing.................!
    msbi course training

    ReplyDelete

Subscribe to: Post Comments (Atom)