is a particular connection member of sysadmin
-
Hi,
do you how to determine if a particular connection is a member of the sysadmin server role ?
For a sql server connection it's easy we just have to check the issysadmin column of the syslogins table. But if we are talking about windows trusted connections it is not so easy.
My windows profile is member of the Administrators group of the server and Builtin\Administrators is member of the sysadmin role so my windows profile is member of the sysadmin server role but my connection is not listed in the syslogins table.
What can I do ?
Thanks for your help !
-
declare @Serveradmin int
Select @Serveradmin = IS_SRVROLEMEMBER ( 'sysadmin')
print @Serveradmin
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
thanks for your reply but it is not a solution to my problem.
I don't want to check my connection, I want to check other connections to the server.
-
How about using EXEC master..xp_logininfo @acctname = 'youruseraccount',@option = 'all'
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
it works !
thanks a lot !
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply