22 May, 2009
Roel van Lisdonk
0 Comments
0 categories
To select all sql database roles query the systusers table and not the sysroles table, because it does not exist. All roles are stored in the sysusers table
select * from dbo.sysusers where issqlrole = 1
Tags: SQL Server
Related Posts
Ajaxification of ASP .NET controls with the Telerik RadAjaxManagerProxy (Master / Content page scenario)
22 December, 2009
Roel van Lisdonk
0 Comments
0 categories
If you have a ASP .NET web application with a…
SQL Server Stored Procedure with temp table select, does not return correct result in LLBLGen Pro
7 May, 2009
Roel van Lisdonk
3 Comments
0 categories
When you create a stored procedure like:if exists (select 1…
2020-06-18 Learned Today
19 June, 2020
Roel van Lisdonk
0 Comments
1 category
Difference between git submodule and git subtree Found a…