Posts

Showing posts from January, 2014

Service Bus Application for Publish/Subscription model

http://imgrouponline.wordpress.com/2012/07/03/windows-azure-servicebus-topic-and-subscription-part-1/ http://imgrouponline.wordpress.com/2012/07/03/windows-azure-servicebus-topic-and-subscription-part-2/ http://robbincremers.me/2012/02/20/windows-azure-service-bus-messaging-with-publishsubscribe-pattern-using-topics-and-subscriptions/

Get Sql DB User Logins and permission levels

select members . name AS UserName , RTRIM ( LTRIM ( roles . name )) AS RoleName from sys . database_principals members inner join sys . database_role_members drm on members . principal_id = drm . member_principal_id inner join sys . database_principals roles on drm . role_principal_id = roles . principal_id WHERE members . name <> 'dbo' ORDER BY roles . name , members . name