[SQL Server ] Cleaner Accounts Inactive

[tincho]

Hi Friends Of ragezone need help in a query to delete inactive accounts on my server


Query

begin tran
delete memb_info
from
(
select memb___id from memb_stat where getdate()-DisConnectTM>365
) tbl
where memb_info.memb___id = tbl.memb___id


Result

Mens. 468, Nivel 16, Estado 9, Línea 7
No se puede resolver el conflicto de intercalación entre "Chinese_PRC_CI_AS" y "Chinese_PRC_CS_AS" de la operación equal to.



Many Thanks for any help

[MentaL]

[invasionGB]

Have no clue if your query is correct, but to avoid that error just change:

This

where memb_info.memb___id = tbl.memb___id

To this

where memb_info.memb___id COLLATE DATABASE_DEFAULT = tbl.memb___id COLLATE DATABASE_DEFAULT

Hope it helps.