spNetAccount_AdminUpdateAccountInformation

        CREATE PROCEDURE dbo.spNetAccount_AdminUpdateAccountInformation
            AS
            BEGIN

                UPDATE NetAccount 
                Set OnlineStatus = 0, OnlineStatusUpdateDate = NULL
                WHERE  
                OnlineStatus = 1 AND
                OnlineStatusUpdateDate IS NOT NULL AND
                DATEDIFF(MINUTE, dateadd(MINUTE,-20,getutcdate()),  OnlineStatusUpdateDate) < 0

                DELETE FROM Message 
                WHERE 
                Deleted = 1 AND
                DeletedDate IS NOT NULL AND
                DATEDIFF(DAY, dateadd(DAY,-5,getutcdate()), DeletedDate) < 0

            END