Restore Database 2005 User Logins

When a database is restored from one server to another user logins are dropped. This script will help rectify that: SET NOCOUNT ON--SELECT 'EXEC sp_change_users_login ''Auto_Fix'', '''+ user_id + ''', NULL, '''+ user_id + ''''SELECT 'EXEC sp_change_users_login ''Auto_Fix'', '''+ user_id + ''', NULL, ''password''' FROM staff s JOIN sys.sysusers su ON su.name = s.user_id WHERE... Continue Reading →

A WordPress.com Website.

Up ↑