\uc190\uc0c1\ub41c \ud14c\uc774\ube14 \ubcf5\uad6c\ud558\uae30 (DBCC CHECKTABLE\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc624\ub958 \ubcf5\uad6c\ud558\uae30) <\/p>\n
\uac1c\ubcc4 \ud14c\uc774\ube14\uc758 \ubb38\uc81c\ub97c \ubcf5\uad6c\ud558\uace0\uc790 \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 DBCC CHECKTABLE \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
[\uad6c\ubb38]
\nDBCC CHECKTABLE
\n( ‘table_name’ | ‘view_name’
\n \t [ , NOINDEX
\n | index_id
\n | { REPAIR_ALLOW_DATA_LOSS
\n | REPAIR_FAST
\n | REPAIR_REBUILD }
\n ]
\n \t) [ WITH { [ ALL_ERRORMSGS | NO_INFOMSGS ]
\n [ , [ TABLOCK ] ]
\n [ , [ ESTIMATEONLY ] ]
\n [ , [ PHYSICAL_ONLY ] ] }
\n \t ]
\n[\ub530\ub77c\ud558\uae30]
\nSELECT DATABASEPROPERTYEX (‘Northwind’, ‘UserAccess’)
\nGO
\n\/* \uacb0\uacfc:
\nMULTI_USER
\n*\/<\/p>\n
ALTER DATABASE Northwind
\nSET SINGLE_USER
\n— 10\ucd08 \ud6c4\uc5d0 \uc644\ub8cc\ub418\uc9c0 \uc54a\uc740 \ud2b8\ub79c\uc7ad\uc158\ub4e4\uc744 \ub864\ubc31
\nWITH ROLLBACK AFTER 10
\nGO<\/p>\n
SELECT DATABASEPROPERTYEX (‘Northwind’, ‘UserAccess’)
\nGO
\n\/* \uacb0\uacfc:
\nSINGLE_USER
\n*\/<\/p>\n
USE Northwind
\nGO
\nDBCC CHECKTABLE (Orders, REPAIR_FAST)
\nGO<\/p>\n
ALTER DATABASE Northwind
\nSET MULTI_USER
\nGO<\/p>\n
— EXEC sp_dboption ‘Northwind’, ‘single user’, ‘FALSE’
\n— GO<\/p>\n
\ucd9c\ucc98 : Tong – darkh9\ub2d8\uc758 DATABASE\ud1b5 <\/p>\n","protected":false},"excerpt":{"rendered":"
\uc190\uc0c1\ub41c \ud14c\uc774\ube14 \ubcf5\uad6c\ud558\uae30 (DBCC CHECKTABLE\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc624\ub958 \ubcf5\uad6c\ud558\uae30) \uac1c\ubcc4 \ud14c\uc774\ube14\uc758 \ubb38\uc81c\ub97c \ubcf5\uad6c\ud558\uace0\uc790 \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 DBCC CHECKTABLE \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. [\uad6c\ubb38] DBCC CHECKTABLE ( ‘table_name’ | ‘view_name’ [ , NOINDEX | index_id | { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ] ) [ WITH { [ ALL_ERRORMSGS | NO_INFOMSGS ] [ , [ TABLOCK ] ] … \uacc4\uc18d \uc77d\uae30 “\uc190\uc0c1\ub41c \ud14c\uc774\ube14 \ubcf5\uad6c\ud558\uae30 (DBCC CHECKTABLE\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc624\ub958 \ubcf5\uad6c\ud558\uae30)”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1470","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1470"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1470\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}