(DIR) Return Create A Forum - Home --------------------------------------------------------- ExcelSoft Database Professionals (HTM) 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 *****************************************************