I almost forgot.
When we tried to move the 6.5 over to the SQL 2000 machine, it compaind alot about stuff that is in sysusers and i heard something abous resyncing database sysusers?
How is this done?
It also reported alot of colums, tables missing that is in sysdata(dont remeber what is was called....)
but it does not really exist in the actual databases....
Is it other "stuff" in master that needs to be "resynced"?
Because alot of tables have been deleted and created over the years but no one has ever done anything in the master database...ever...
at least i dont think so