Hi Alex, when you tried to recreate the error was the account you deleted already unauthorized.

I recreated the error on my local system and it happened exactly the same.  If you authorize the user, before you delete, then this bug does not occur.

Thanks Alex, out of desperation I've come up with my own fix.  There are probably many things wrong with doing this (so I wouldn't recomment it to anyone else - I'm not sure what knock on effects this could have) but if anyone can see a better way around it let me know.

I've run this change to the SQL.  They key to this is the addiiton of the line "AND IsDeleted = 0"

ALTER PROCEDURE dbo.GetUnAuthorizedUsers
    @PortalID            int
AS

SELECT  *
FROM    dbo.vw_Users
WHERE  PortalId = @PortalID
    AND Authorised = 0
    AND IsDeleted = 0
ORDER BY UserName