• Add COLLATE DATABASE_DEFAULT to table variable definition

    DECLARE @WeakPwdList TABLE(WeakPwd NVARCHAR(255) COLLATE DATABASE_DEFAULT )