{"id":269,"date":"2010-12-07T11:08:52","date_gmt":"2010-12-07T03:08:52","guid":{"rendered":"http:\/\/zduo.me\/blog\/?p=269"},"modified":"2010-12-07T11:08:52","modified_gmt":"2010-12-07T03:08:52","slug":"the-database-could-not-be-exclusively-locked-to-perform-the-operation%ef%bc%88sql-server-5030%e9%94%99%e8%af%af%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95%ef%bc%89","status":"publish","type":"post","link":"http:\/\/zduo.me\/blog\/?p=269","title":{"rendered":"The database could not be exclusively locked to perform the operation\uff08SQL Server 5030\u9519\u8bef\u89e3\u51b3\u529e\u6cd5\uff09"},"content":{"rendered":"<p>SQL Server 5030\u9519\u8bef\u89e3\u51b3\u529e\u6cd5<\/p>\n<p>\u4eca\u5929\u5728\u4f7f\u7528SQL Server\u65f6\uff0c\u7531\u4e8e\u4e4b\u524d\u521b\u5efa\u6570\u636e\u5e93\u5fd8\u8bb0\u4e86\u8bbe\u7f6eCollocation\uff0c\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u4e2d\u6587\u5b57\u7b26\u90fd\u662f\u4e71\u7801\uff0c\u4e8e\u662f\u5230DataBase\u7684Options\u4e2d\u4fee\u6539Collocation\uff0c\u51fa\u73b0\u4e86The database could not be exclusively locked to perform the operation\u8fd9\u4e2a\u9519\u8bef\uff0c\u65e0\u6cd5\u4fee\u6539\u5b57\u7b26\u96c6\u4e3aChinese_PRC_90_CI_AS\u3002<\/p>\n<p>\u89e3\u51b3\u529e\u6cd5\u627e\u4e86\u5f88\u4e45\u624d\u627e\u5230\uff0c\u5982\u4e0b\uff1a<\/p>\n<p>1.\u6267\u884cSQL <span style=\"color: #ff0000;\">ALTER DATABASE db_database SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/span><\/p>\n<p>\u4fee\u6539\u4e3a\u5355\u7528\u6237\u6a21\u5f0f<\/p>\n<p>2.\u7136\u540e\u5173\u95ed\u6240\u6709\u7684\u67e5\u8be2\u7a97\u53e3\uff0c\u4fee\u6539Options\u7684Collocation\u5c5e\u6027\u4e3aChinese_PRC_90_CI_AS<\/p>\n<p>3.\u6267\u884cSQL <span style=\"color: #ff0000;\">ALTER DATABASE db_database SET MULTI_USER<\/span><\/p>\n<p>\u518d\u4fee\u6539\u4e3a\u591a\u7528\u6237\u6a21\u5f0f<\/p>\n<div id=\"MySignature\">\n<div>\u4f5c\u8005\uff1a<a href=\"http:\/\/www.cnblogs.com\/psunny\">Sunny Peng<\/a><\/div>\n<div>\u51fa\u5904\uff1a<a href=\"http:\/\/www.cnblogs.com\/psunny\">http:\/\/www.cnblogs.com\/psunny\/<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 5030\u9519\u8bef\u89e3\u51b3\u529e\u6cd5 \u4eca\u5929\u5728\u4f7f\u7528SQL Server\u65f6\uff0c\u7531\u4e8e\u4e4b\u524d\u521b\u5efa\u6570\u636e\u5e93\u5fd8\u8bb0\u4e86\u8bbe\u7f6eCollocation\uff0c\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u4e2d\u6587\u5b57\u7b26\u90fd\u662f\u4e71\u7801\uff0c\u4e8e\u662f\u5230DataBase\u7684Options\u4e2d\u4fee\u6539Collocation\uff0c\u51fa\u73b0\u4e86The database could not be exclusively locked to perform the operation\u8fd9\u4e2a\u9519\u8bef\uff0c\u65e0\u6cd5\u4fee\u6539\u5b57\u7b26\u96c6\u4e3aChinese_PRC_90_CI_AS\u3002 \u89e3\u51b3\u529e\u6cd5\u627e\u4e86\u5f88\u4e45\u624d\u627e\u5230\uff0c\u5982\u4e0b\uff1a 1.\u6267\u884cSQL ALTER DATABASE db_database SET SINGLE_USER WITH ROLLBACK IMMEDIATE \u4fee\u6539\u4e3a\u5355\u7528\u6237\u6a21\u5f0f 2.\u7136\u540e\u5173\u95ed\u6240\u6709\u7684\u67e5\u8be2\u7a97\u53e3\uff0c\u4fee\u6539Options\u7684Collocation\u5c5e\u6027\u4e3aChinese_PRC_90_CI_AS 3.\u6267\u884cSQL ALTER DATABASE db_database SET MULTI_USER \u518d\u4fee\u6539\u4e3a\u591a\u7528\u6237\u6a21\u5f0f \u4f5c\u8005\uff1aSunny Peng \u51fa\u5904\uff1ahttp:\/\/www.cnblogs.com\/psunny\/<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[57],"tags":[168,58],"_links":{"self":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/269"}],"collection":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=269"}],"version-history":[{"count":1,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/269\/revisions"}],"predecessor-version":[{"id":270,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=\/wp\/v2\/posts\/269\/revisions\/270"}],"wp:attachment":[{"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zduo.me\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}