if a backup of a database was created on SERVER A, and Restored on SERVER B, you would find that behavior...all users in the db are "orphaned";
i'd guess that if someone keeps re-restoring the db in question, that that is what you are seeing.that's what you are seeing.
BOB on SERVER A is not necessarily BOB on server B. dropping and re-adding BOB establishes the tie from localdatabase..sysusers to master..syslogins again.
syslogins has a unique SID that is used to determine who BOB really is.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!