Database Transfer MsSql server Sync sid . 데이타베이스 이전시에 아이디 싱크
ALTER Procedure [dbo].[usp_SyncLoginSid](@_LoginID varchar(30), @_DBName varchar(30))
AS
Begin
declare @_LoginID varchar(30)
declare @_DBName varchar(30)
set @_LoginID = ‘LoginID’
set @_DBName = ‘DatabaseName’
declare @vBinSid varbinary(85)
select @vBinSid = sid
From felis.dbo.sysusers where name = @_LoginID
exec sp_addlogin @_LoginID,’ ‘, @_DBName, @sid= @vBinSid
End
in ms sql 2008
without master db
—————how to create new login and sync
use DatabaseName
declare @sid varvanary
select @sid=sid from sysusers where name=’DatabaseName’
create login LoginID with password=’LoginID’, SID=@sid, check_policy=OFF