text: ﻿CREATE VIEW [dbo].[vw_aspnet_MembershipUsers]
    AS SELECT [dbo].[aspnet_Membership].[UserId],
              [dbo].[aspnet_Membership].[PasswordFormat],
              [dbo].[aspnet_Membership].[MobilePIN],
              [dbo].[aspnet_Membership].[Email],
              [dbo].[aspnet_Membership].[LoweredEmail],
              [dbo].[aspnet_Membership].[PasswordQuestion],
              [dbo].[aspnet_Membership].[PasswordAnswer],
              [dbo].[aspnet_Membership].[IsApproved],
              [dbo].[aspnet_Membership].[IsLockedOut],
              [dbo].[aspnet_Membership].[CreateDate],
              [dbo].[aspnet_Membership].[LastLoginDate],
              [dbo].[aspnet_Membership].[LastPasswordChangedDate],
              [dbo].[aspnet_Membership].[LastLockoutDate],
              [dbo].[aspnet_Membership].[FailedPasswordAttemptCount],
              [dbo].[aspnet_Membership].[FailedPasswordAttemptWindowStart],
              [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptCount],
              [dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],
              [dbo].[aspnet_Membership].[Comment],
              [dbo].[aspnet_Users].[ApplicationId],
              [dbo].[aspnet_Users].[UserName],
              [dbo].[aspnet_Users].[MobileAlias],
              [dbo].[aspnet_Users].[IsAnonymous],
              [dbo].[aspnet_Users].[LastActivityDate]
    FROM [dbo].[aspnet_Membership] INNER JOIN [dbo].[aspnet_Users]
        ON [dbo].[aspnet_Membership].[UserId] = [dbo].[aspnet_Users].[UserId]