Procedure: aspnet_Roles_GetAllRoles

Description

Retrieves all roles with the specified application ID from the aspnet_Roles table.

Parameters

Name	Type	Direction
@ApplicationName	nvarchar	Input

Definition

CREATE PROCEDURE dbo.aspnet_Roles_GetAllRoles (
    @ApplicationName           nvarchar(256))
AS
BEGIN
    DECLARE @ApplicationId uniqueidentifier
    SELECT  @ApplicationId = NULL
    SELECT  @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
    IF (@ApplicationId IS NULL)
        RETURN
    SELECT RoleName
    FROM   dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
    ORDER BY RoleName
END

---

ASP.NET 2.0 Provider Database