Home Forums SQL Server 2005 SQL Server 2005 General Discussion restore a database to a new SQL 2005 SERVER RE: restore a database to a new SQL 2005 SERVER
koen_huys
Old Hand
Points: 337
More actions
December 11, 2014 at 1:21 am
#1763968
resolved with the below query
USE [database];
Go
sp_change_users_login @Action= 'update_one', @UserNamePattern=,
@LoginName=[loginname];
GO