I have two servers, one Production, one query for Reports with SQL 7.0. I run a backup on Production and restore to Reports and my Reports users suid are null until I run sp_change_users_login “Auto_Fix’, loginname. Any way around this?? This is done once a week.
