shanila_minnu
Hall of Fame
Points: 3465
More actions
March 23, 2010 at 7:35 am
#216908
how can i know , which all windows logins are having access to the sql server. i want to forward the unwanted login names to server team to remove it from the server
Joy Smith San
SSC-Insane
Points: 24877
March 23, 2010 at 7:51 am
#1138226
select * from sys.syslogins
or
sp_helplogins
Shawn Melton
Points: 24685
March 23, 2010 at 8:03 am
#1138233
mis-read post
Shawn MeltonTwitter: @wsmeltonBlog: wsmelton.github.comGithub: wsmelton
dbychen
SSCommitted
Points: 1889
March 23, 2010 at 8:19 am
#1138248
Please try below for each instance:
SELECT name AS 'Login_Name'
,default_database_name AS 'Default_Database'
,is_disabled AS 'Status'
FROM sys.server_principals
WHERE type_desc = 'Windows_Login'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply