{"id":425,"date":"2016-04-04T16:42:54","date_gmt":"2016-04-04T07:42:54","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=425"},"modified":"2016-04-04T16:42:54","modified_gmt":"2016-04-04T07:42:54","slug":"mssql-single-user-mode-to-multiuser","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/04\/04\/mssql-single-user-mode-to-multiuser\/","title":{"rendered":"mssql single user mode to multiuser"},"content":{"rendered":"<p>use master<br \/>\nGO<\/p>\n<p>select<br \/>\nd.name,<br \/>\nd.dbid,<br \/>\nspid,<br \/>\nlogin_time,<br \/>\nnt_domain,<br \/>\nnt_username,<br \/>\nloginame<br \/>\nfrom sysprocesses p<br \/>\ninner join sysdatabases d<br \/>\non p.dbid = d.dbid<br \/>\nwhere d.name = &#8216;database_name&#8217;<br \/>\nGO<\/p>\n<p>kill 56 =&gt; kill the number in spid field<br \/>\nGO<\/p>\n<p>exec sp_dboption &#8216;database_name&#8217;, &#8216;single user&#8217;, &#8216;FALSE&#8217;<br \/>\nGO<\/p>\n","protected":false},"excerpt":{"rendered":"<p>use master GO select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid where d.name = &#8216;database_name&#8217; GO kill 56 =&gt; kill the number in spid field GO exec sp_dboption &#8216;database_name&#8217;, &#8216;single user&#8217;, &#8216;FALSE&#8217; GO<\/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-425","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\/425","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=425"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":426,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/425\/revisions\/426"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}