It seens that a simple script:
Update sysxlogins set name = 'AA001' + substring(name, 9, LEN(name)-8
)
where name like 'ILLINOIS%'
Will replace the SQL2000 domain name correctly in sysxlogins:
ILLINOIS\JonesP becomes AA001\JonesP
But for some strange reason via ILLINOIS\JonesP can still logon via
QueryAnalyzer although he is no longer in the sysxlogins table
anymore? SQL has been stop/started, server even rebooted, yet BOTH
the new and old logins seem to both allow QA login, any thought how
the old one is getting thru SQL security?
thanks in advance for any help...