sp_configure 'allow updates',1 go reconfigure with override go update NNNNNN.dbo.sysusers set NNNNNN.dbo.sysusers.sid=u.sid from NNNNNN.dbo.sysusers o, master.dbo.sysxlogins u where u.name='tradelite' and o.name='tradelite' Go sp_configure 'allow updates',0 go reconfigure with override go