spLoadRecord_NetAccount_ByEmail

        CREATE PROCEDURE [dbo].[spLoadRecord_NetAccount_ByEmail]
            (
            @EmailAddress nvarchar(255)
            )
            AS

            SELECT 
            ID, 
            DisplayName, 
            EmailAddress, 
            ClientUsersID, 
            CreateDate, 
            UpdateDate,
            LockedOut, 
            LockedDate, 
            LockedUserID, 
            Deleted, 
            DeletedDate, 
            DeletedUserID,
            EmailForwardingEnabled,
            UserPageURL,
            OnlineStatus ,
            OnlineStatusPreferenceType,
            OnlineStatusUpdateDate,
            ProfileImageID
            from [NetAccount] where EmailAddress = @EmailAddress

            RETURN