Discussion Locked
SQL 7.0 null suid after restore
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.