Display only windows logins for SQL Server
2001-08-22
366 reads
Robert-Vallee,
2001-08-22
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
You rated this post out of 5. Change rating
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads
2001-08-22
541 reads