This week i had the honor to test a G2-Series HP I/O-Accellerator Card. Installation and Post-Configuration of the card is very easy. So you could go ahead immediately with testing these Hot Stuff. We configured the card to 50% Performance, so we loosed 50% of the available space on the I/O-Card. But for our reasons,... Continue Reading →
Hey Guy's here i am with my 1st SQL-Server Post! If you want to know the membership of a database role, to what other database roles the role belongs to, i have a good satatement for you.
SELECT dbrole1.name AS dbrole1_name
, dbrole2.name AS dbrole2_name
FROM sys.database_principals AS dbrole1
JOIN sys.database_role_members AS dbrm
ON dbrm.member_principal_id = dbrole1.principal_id
JOIN sys.database_principals AS dbrole2
ON dbrole2.principal_id = dbrm.role_principal_id
WHERE dbrole1.name LIKE 'myRole%'
ORDER BY dbrole1.name ASC