Table Partitioning

scripts required to pull the users tied up with the roles , AD groups , Group Members and their roles.   Query-1 — Adgroups , Group members , Roles assigned. SET NOCOUNT ON DECLARE @PERMISSION TABLE( DATABASE_NAME SYSNAME, USER_ROLE_NAME SYSNAME, ACCOUNT_TYPE NVARCHAR(60 ), ACTION_TYPE NVARCHAR(128), PERMISSION NVARCHAR(60), OBJECTNAME SYSNAME NULL, OBJECT_TYPE NVARCHAR(60), HAS_DB_ACCESS BIT )…