DIR Return Create A Forum - Home
       ---------------------------------------------------------
       ExcelSoft Database Professionals
  HTML https://esdbp.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Scripts
       *****************************************************
       #Post#: 90--------------------------------------------------
       Find Windows Group for a Login
       By: srinivasma_exceldbp Date: November 5, 2014, 9:55 pm
       ---------------------------------------------------------
       USE [master]
       GO
       SET ANSI_NULLS ON
       GO
       SET QUOTED_IDENTIFIER ON
       GO
       USE master
       GO
       IF OBJECT_ID('sp_lib_WindowGroupsForLogin') > 0
       BEGIN
       DROP PROC sp_lib_WindowGroupsForLogin
       END
       GO
       /*
       USAGE
       exec dbo.sp_lib_WindowGroupsForLogin 'domain\windowsgroup'
       exec dbo.sp_lib_WindowGroupsForLogin 'excelindia\SARAS'
       Description 
       Windows Group and Usage
       
       Server 
       Database 
       Input Parameters: Login Name -- @loginname
       Output Parameter: None
       Return Value 
       Other Outputs 
       Created Date 
       reated_By 
       Modified Date 
       Modified By 
       Modified Version:
       Modifications 
       Called By 
       Calling 
       */
       create procedure dbo.sp_lib_WindowGroupsForLogin
       @loginname sysname
       as
       begin
       execute as login = @loginname
       select name as groupname,usage as usage
       from sys.login_token
       where type = N'WINDOWS GROUP';
       end ;
       go
       exec sp_ms_marksystemobject 'sp_lib_WindowGroupsForLogin'
       go
       grant exec on sp_lib_WindowGroupsForLogin to public
       go
       *****************************************************