MS SQL – Count Users In User Role

Posted on By David Kittell 
SELECT UR.[Id]
,UR.[Name]
,COUNT(ur.name)
FROM [dbo].[UserRole] UR
INNER JOIN dbo.[User] U ON U.Role = UR.Id 
GROUP BY UR.Id, ur.Name
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL MSSQL - Audit SQL

Related Posts

Count All Rows In All Tables

Posted on

There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows. SELECT t.NAME AS table_name ,i.rows FROM sys.tables AS t…

Read More

Show Stored Procedures

Posted on

SELECT so.NAME ,created ,last_altered ,specific_catalog ,routine_definition ,sql_data_access FROM sys.objects so LEFT OUTER JOIN information_schema.routines sr ON so.NAME = sr.specific_name WHERE objectproperty(object_id, N’IsMSShipped’) = 0 AND objectproperty(object_id, N’IsProcedure’) = 1 ORDER BY created DESC ,NAME SELECT * FROM information_schema.routines WHERE routine_type = ‘PROCEDURE’ ORDER BY specific_name SELECT * FROM sys.objects WHERE…

Read More