\u56e0\u70ba\u4e00\u4e9b\u7db2\u7ad9\u662f\u4f7f\u7528\u865b\u64ec\u4e3b\u6a5f\u3002\u7528sql-server\u5c0e\u6578\u64da\u4e0a\u53bb\u7684\u8a71\uff0c\u6578\u64da\u5eab\u7684\u7528\u6236\u9ed8\u8a8d\u662f\u4f60\u767b\u9304\u7684\u7528\u6236\uff0c\u4e0d\u662fdbo\uff0c\u6709\u6642\u5c31\u548c\u672c\u5730\u7522\u751f\u4e0d\u4e00\u81f4\u3002<\/p>\n
–\u529f\u80fd\u8aaa\u660e\uff1a\u6210\u6279\u66f4\u6539\u6578\u64da\u5eab\u6240\u6709\u8005\u7684\u5c0d\u8c61<\/p>\n
–\u7528\u6cd5\uff1aexec ChangeObjectOwner ‘nmkspro’,’dbo’<\/p>\n
–\u5373\u53ef\u5c07\u6240\u6709nmkspro\u6240\u6709\u8005\u7684\u5c0d\u8c61\u6539\u70badbo\u6240\u6709 Chinaz~com<\/span><\/p>\n –\u904b\u884c\u6210\u529f\u5f8c\u5c07\u63d0\u793a\uff1a”\u6ce8\u610f: \u66f4\u6539\u5c0d\u8c61\u540d\u7684\u4efb\u4e00\u90e8\u5206\u90fd\u53ef\u80fd\u7834\u58de\u8173\u672c\u548c\u5b58\u5132\u904e\u7a0b\u3002” <\/span> DECLARE @Name as NVARCHAR(128) ————————————————————– \u55ae\u500b\u4fee\u6539\uff1a ————————————————————– \u65b9\u6cd5\u4e8c\uff1a\u5229\u7528\u8173\u672c\u76f4\u63a5\u57f7\u884c\uff0c\u7528\u7cfb\u7d71\u5e33\u865f\u6216\u8005\u767b\u9678\u5230\u8a72\u6578\u64da\u5eab\uff0c\u7136\u5f8c\u57f7\u884c\u4e0b\u9762\u8a9e\u53e5\uff1a \u56e0\u70ba\u4e00\u4e9b\u7db2\u7ad9\u662f\u4f7f\u7528\u865b\u64ec\u4e3b\u6a5f\u3002\u7528sql-server\u5c0e\u6578\u64da\u4e0a\u53bb\u7684\u8a71\uff0c\u6578\u64da\u5eab\u7684\u7528\u6236\u9ed8\u8a8d\u662f\u4f60\u767b\u9304\u7684\u7528\u6236\uff0c\u4e0d\u662fdbo\uff0c … \u95b1\u8b80\u5168\u6587 \u6279\u91cf\u66f4\u6539sql server\u6578\u64da\u5eab\u6240\u6709\u8005\u7684\u5c0d\u8c61<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-5","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nCREATE PROCEDURE dbo.ChangeObjectOwner
\n@OldOwner as NVARCHAR(128),–\u53c3\u6578\u539f\u6240\u6709\u8005
\n@NewOwner as NVARCHAR(128)–\u53c3\u6578\u65b0\u6240\u6709\u8005
\nAS<\/p>\n
\nDECLARE @Owner as NVARCHAR(128)
\nDECLARE @OwnerName as NVARCHAR(128) <\/span>DECLARE curObject CURSOR FOR
\nselect ‘Name’ = name,
\n‘Owner’ = user_name(uid)
\nfrom sysobjects
\nwhere user_name(uid)=@OldOwner
\norder by name
\nOPEN curObject
\nFETCH NEXT FROM curObject INTO @Name, @Owner
\nWHILE(@@FETCH_STATUS=0)
\nBEGIN
\nif @Owner=@OldOwner
\nbegin
\nset @OwnerName = @OldOwner + ‘.’ + rtrim(@Name)
\nexec sp_changeobjectowner @OwnerName, @NewOwner
\nend Chinaz~com<\/span>
\nFETCH NEXT FROM curObject INTO @Name, @Owner
\nEND
\nclose curObject
\ndeallocate curObject
\nGO<\/p>\n
\n\u6279\u91cf\u4fee\u6539\uff1a
\nEXEC sp_MSforeachtable ‘exec sp_changeobjectowner ”?”,”dbo” ‘<\/p>\n
\nexec sp_changeobjectowner ‘\u8981\u6539\u7684\u8868\u540d’,’dbo’<\/span><\/p>\n
\n\u65b9\u6cd5\u4e00\uff1a\u76f4\u63a5\u9ede\u64ca\u8a72\u8868-\u300b\u8a2d\u8a08-\u300b\u5c6c\u6027-\u300b\u66f4\u6539\u4e0a\u9762\u7684\u6240\u6709\u8005\u3002\u8a72\u65b9\u6cd5\u91dd\u5c0d\u65bc\u8868\u5c11\u7684\u60c5\u6cc1\u4e0b\u3002<\/p>\n
\nsp_configure ‘allow updates’,’1′
\ngo
\nreconfigure with override
\ngo
\nupdate sysobjects set uid=1 where uid<>1 –\u6839\u64da\u689d\u4ef6\u53ef\u4ee5\u4efb\u610f\u4fee\u6539\uff0c\u5728\u591a\u7528\u6236\u4e4b\u9593\u5207\u63db\u3002
\ngo
\nsp_configure ‘allow updates’,’0′
\ngo
\nreconfigure with override \u7ad9\u9577.\u7ad9<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"