This code snippet might help:

use DatabaseNameHere

go

EXEC sp_change_users_login 'REPORT'

EXEC sp_change_users_login 'UPDATE_ONE','user','user'

This worked to resynch orphaned logins for me. Just put your database name in line one above and your orphaned...

I have a similar problem on a client server - after a couple of days the connections to SQL Server 2000 become very slow and start to fail.  When this...

Many thanks - I'll try the sample code from the Microsoft site. Fingers crossed...