DotNetNuke - Useful SQL Server Queries
========================
Stored Procedures
========================
exec aspnet_UsersInRoles_AddUsersToRoles 'DotNetNuke', 'pclady', 'Administrators', null
exec aspnet_Membership_GetAllUsers 'DotNetNuke', 1, 2
exec aspnet_Roles_GetAllRoles 'DotNetNuke'
exec aspnet_UsersInRoles_GetRolesForUser 'DotNetNuke', 'pclady'
exec GetRoles
exec aspnet_Membership_GetUserByName 'DotNetNuke', 'pclady', null
exec aspnet_UsersInRoles_FindUsersInRole
exec aspnet_UsersInRoles_FindUsersInRole 'DotNetNuke', 'Administrators', 'pclady'
exec GetUser 0, 3
exec GetUserRoles 0, 3
exec aspnet_UsersInRoles_GetUsersInRoles 'DotNetNuke', 'Administrators'
========================
SQL Statements
========================
select * from aspnet_Users
select * from aspnet_Membership
UPDATE Users
SET UpdatePassword = true
where userid = 2
|


Comments