select * from master..syslogins
where sysadmin = 1




>-----Original Message-----
>Is there any way to determine if a login has system
administrator rights?
>
>
>.
>

Report this post to a moderator

Also to note,

sp_helpsrvrolemember 'sysadmin' gives the list of members in the sysadmin
role.


Thanks,

Vikrant Dalwale

Microsoft SQL Server Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure ! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------
>Content-Class: urn:content-classes:message
>From: "andrew powell" <andy@paisleysoft.com>
>Sender: "andrew powell" <andy@paisleysoft.com>
>References: <ON3yTnIPCHA.2420@tkmsftngp11>
>Subject: Determining if a login has administrator rights.
>Date: Mon, 5 Aug 2002 07:21:26 -0700
>Lines: 13
>Message-ID: < 0bbe01c23c8b$61fb1200$37ef2ecf
@TKMSFTNGXA13>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Thread-Index: AcI8i2H4NL5YDXK9RJu7aNd9GD5ZMw
==
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TKMSFTNGXA13 10.201.226.41
>Path: cpmsftngxa08!cpmsftngxa07
>Xref: cpmsftngxa08 microsoft.public.sqlserver.server:222790
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>select * from master..syslogins
>where sysadmin = 1
>
>
>
>
>>-----Original Message-----
>>Is there any way to determine if a login has system
>administrator rights?
>>
>>
>>.
>>
>

Report this post to a moderator