{"id":441,"date":"2016-12-10T13:50:41","date_gmt":"2016-12-10T04:50:41","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=441"},"modified":"2016-12-10T13:50:59","modified_gmt":"2016-12-10T04:50:59","slug":"441","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/12\/10\/441\/","title":{"rendered":"Database Transfer MsSql server Sync sid . \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\uc804\uc2dc\uc5d0 \uc544\uc774\ub514 \uc2f1\ud06c"},"content":{"rendered":"<p>Database Transfer MsSql server Sync sid . \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\uc804\uc2dc\uc5d0 \uc544\uc774\ub514 \uc2f1\ud06c<\/p>\n<p>ALTER Procedure [dbo].[usp_SyncLoginSid](@_LoginID varchar(30), @_DBName varchar(30))<\/p>\n<p>AS<\/p>\n<p>Begin<\/p>\n<p>declare @_LoginID varchar(30)<\/p>\n<p>declare @_DBName varchar(30)<\/p>\n<p>set @_LoginID = &#8216;LoginID&#8217;<\/p>\n<p>set @_DBName = &#8216;DatabaseName&#8217;<\/p>\n<p>declare @vBinSid varbinary(85)<\/p>\n<p>select @vBinSid = sid<\/p>\n<p>From felis.dbo.sysusers where name = @_LoginID<\/p>\n<p>exec sp_addlogin @_LoginID,&#8217; &#8216;, @_DBName, @sid= @vBinSid<\/p>\n<p>End<\/p>\n<p>in ms sql 2008<\/p>\n<p>without master db<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;how to create new login and sync<\/p>\n<p>use DatabaseName<\/p>\n<p>declare @sid varvanary<\/p>\n<p>&nbsp;<\/p>\n<p>select @sid=sid from sysusers where name=&#8217;DatabaseName&#8217;<\/p>\n<p>create login LoginID\u00a0with password=&#8217;LoginID&#8217;, SID=@sid, check_policy=OFF<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Transfer MsSql server Sync sid . \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\uc804\uc2dc\uc5d0 \uc544\uc774\ub514 \uc2f1\ud06c ALTER Procedure [dbo].[usp_SyncLoginSid](@_LoginID varchar(30), @_DBName varchar(30)) AS Begin declare @_LoginID varchar(30) declare @_DBName varchar(30) set @_LoginID = &#8216;LoginID&#8217; set @_DBName = &#8216;DatabaseName&#8217; declare @vBinSid varbinary(85) select @vBinSid = sid From felis.dbo.sysusers where name = @_LoginID exec sp_addlogin @_LoginID,&#8217; &#8216;, @_DBName, @sid= @vBinSid End in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-441","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=441"}],"version-history":[{"count":2,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/441\/revisions"}],"predecessor-version":[{"id":443,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/441\/revisions\/443"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}