hx_Windows_Logins

,

Display only windows logins for SQL Server

drop procedure hx_Windows_Logins
go
/* Robert Vallee 04/11/2001
rvallee@hybridx.com
input:None
output:Table format
Desc:Display only windows logins for SQL Server.
Warnings: None.
*/CREATE procedure hx_Windows_Logins as

set nocount on
create table #tempNT (
[account name] varchar(55),
type varchar(25),
privilege varchar (25),
[mapped login name] varchar (66),
[permission path] varchar(66)
)

insert into #tempNT([account name],type,privilege,[mapped login name],[permission path])
EXEC master..xp_logininfo 'BUILTIN\Administrators',@option = 'members' 

select [account name],type,privilege,[mapped login name] from #tempNT

Drop table #tempNT

Rate

Share

Share

Rate