??????? ??????? ???????? ??? DBCC 2570 ?? SQL Server 2005 ?? ????????? ??????

?????? ????????? ?????? ?????????
???? ???????: 923247 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

???? ??? ??????? ??? SQL Server 2570? ?? ?? ????? ?????? ?????? ?? ???????.

??????? ????

????? DATA_PURITY

?? SQL Server 2005? ?? ????? ???? ????? DATA_PURITY? ??? ????? DBCC CHECKDB ? DBCC CHECKTABLE. ??? ????? DBCC CHECKDB ?? ????? DBCC CHECKTABLE ?????? ??? ??????? ???? ????? ????? ?????? ?????? ?? ??? "???? ????????" ??? ?? ???? ?????? ?? ???? ?????? ?? ?????? ?? ??????? ?? ????? ????????. ??? ????? ?????? ?????? ??????? ??? ?????? ?? ?? ??? ????? ??????? ?? ??????? (?? ????? ??? ?????? ???? ?????? ?????? ??????? ???? ???????? ??? ??????). ????? ??????? ?????? ?? ??? ????? ????? ??? ??? ?????? ??????. ????? ????? ??? ????? ???? ??? ???????:
?? ??? ??????????? ??? ??????
??? ?????? ????????? ?????? ?? ????????
??? Unicode??? ?? ???? ??? ???????? ????? ????? 2.
??????? ????????? ?? ???? ????? ?????? ??? ????? 1753 1 ? 31 ?????? 9999. ??? ?? ???? ????? time ???? ?? 11:59:59:999 ?.
???????? ??????????????? ?? ???? ???? ?? ??? ??????? ??????? ????? ????? ????? ???????? PD? ????.
???? ???? ????? ???????? ??? ?????? ?? ??? ?????? ??????. ??? ??? ???? ?? ?????? ?? ???? ????? ???? ??? ?????? ?? ??????. ??? ???? ??????? ????? ???? ???? ?? 0 ??? 255 ??? ???????? ??? ???? ???? ???? ???? ??????? ?? ????? ?????? (????? ????? ????? ????? ?? 0 ??? 255)? ??? ?????? ?? ???? ??? ?? ???????.

?? ??? ????? ?????? ?????? ?? ??? ???? ???????? ???????? ????? ????? ????????. ??? ????? ????????? ???????? ??? ??? ?????:
  • ?????? ???????? ???? ?? ??????? ?? SQL Server 2005 ?? ????????? ??????? ??? ?????????? ??? ??????? ???? ??????? ??? ???? ??????? ??? ??? ?????? ???????? ???? "DATA_PURITY" ??? ????? ??? DBCC CHECKDB ?? DBCC CHECKTABLE.
  • ?????? ???????? ???? ?? ??????? ?? ????????? ??????? ?? SQL ????? ??? SQL Server 2000 ?? SQL Server 7.0 ???????? ??????? ??? SQL ?? ??? ????? ???? 2005? ?????? ??????? ??? ???? ???????. ?? ??? ?????? ?????? ??? ??????? ??? ????? ???? DATA_PURITY ?? DBCC CHECKDB ?? ??? DBCC CHECKTABLE. ???? ?? ???? ??? ??? ?????:
    • ????? ????? DBCC ???? ????? ???????? ?????? ??? ?? ??? ???? ????????? ???? ????????. ??? ????? ??? ??????? ?? ??? ????? ????????. ????? DBCC CHECKDB ?? DBCC CHECKTABLE ??????? ???? ??????? ??????? ??? ????? ??? ????????? ????? ????? ???????? ???????? ????? ????? ??? ???? ?? ???? ?????? ???????? ???? ?? ??????? ??? SQL Server 2005. ?? ????? ???? ????? ????? ?????? ?? ??????? ?? ???? "?????" ?????? ???? ???????? ????? ??????.
    • ????? ????? DBCC ???? ?????? ????? ??? ??? ????? ????????. ??? ???? ??? ?? ??????? ??? ????? ????? ???????? ????? ????????? ??????? ?????? ????? DBCC ??? ????. ??? ????? ???? DATA_PURITY ????? DBCC ??? ?? ??????? ?? ????? ?????? ?????.
  • ??? ?? ????? ?????? PHYSICAL_ONLY ??? DBCC ??? ????? ????? CHECKDB ?? DBCC CHECKTABLE? ?? ??? ????? ???? ???????? ?????.

???????

?? ??? ????? ?????? ??? ????? ?? ???? ?????? ?? SQL ???? ????? ???????? ?? ????????? ??????? ??????? ???????:
  • ?????? ??? ????? ???? ?????? ?? ?????? ????? ??????? ???? ????? ???? ??? ?????? ???????? bcp.
  • ?? ????? ?????? ??? ????? ?? ???? ????? ????????? ????? RPC ???? SQL.
  • ??????? ?????? ???????? ???? ??? ?? ???????? ??????? ???? ?????? ?? ???? ??? ?????.
??? ??? ???? ?????? ??? ????? ?? ???? ????? ??? ????? ????? ???????? ??? ??? ??????? ???? ??? ??? ???????? ??? ?????. ??? ???? ?? ?????? ???? ?? ???? ?? ?????? ??? ??? ?????? ???????? ??? ??????? ??? ???? ?????? ??? DBCC CHECKDB ?? DBCC CHECKTABLE ?? SQL Server 2005 ?????????? ??????.

??? ??????? ???? ?? ????? ????? ????? ?????? ??? ????? ???? (??? ???? ?????? ?? ????? ???):
  • ?????? ??? ?????? ?? ????? ???? ?? ??????????? ????? ????? ????????? ????? ?????? ???????.
  • ??? ??????? ?????? ??????????? ???? ?? ??????? ??? ????? ??? ????? ?????? ???????.
  • ????? ?? ????? ??? ?????????? ???? ???? ?? ??????? ????????.
  • ????? ??????? ??? ???:
    Msg 9100? 23 ?????? ?????? 2? ?? ????? ?? ??? ???? "??? 1 ????????". ????? DBCC CHECKDB.

????? ????? DATA_PURITY

??? ????? ??? DBCC CHECKDB ?? DBCC CHECKTABLE ?? ????? ???? DATA_PURITY (?? ?? ????? ?????? ???? ???????? ????????)? ????? ?????? ??? ????? ?? ??????? ??? DBCC ?????? ????? ????? DBCC ?????? ?? ??????? ???? ???? ??? ????? ?? ????????. ??? ????? ??? ???? ???? ???? ???????? ????? ????? ?????:
????? DBCC "account_history".
Msg 2570 ?? ????? 16, ???? 2? ??? 1
?????? (1:1073) ?????? 33 ?? ???? ???? 1977058079? ???? ???? 0? ??? 129568478265344 ????? ???? ????? ???? 129568478265344 (????? "?? ?? ??????"). ?????? "account_name_japan" ?????? ???? ?????? ???? ???????? "nvarchar". ????? ???? ????? ????? ???.
Msg 2570 ?? ????? 16, ???? 2? ??? 1
?????? (1:1156)? ????? 120 ?? ???? 1977058079 ????? ???? ???? 0? ????? 129568478265344 ????? ???? ???? ????? 129568478265344 (???? "?? ?? ??????"). ???? ?????? "account_name_japan" ??????? ?????? ???? ???????? "nvarchar". ????? ???? ????? ????? ???.
???? ??? 153137 ?????? ???????? ?? ????? 1080 ?????? "account_history".
?? ?????? ??? CHECKDB ????? 0 ????? ?????? ????? 338 ?? ?????? "account_history" (???? ???? 1977058079).
CHECKDB ?????? ??? ????? ??????? 0 ? 338 ????? ????? ?? ????? ???????? '??????????????'.
?? ??????? DBCC. ??? DBCC ????? ????? ??????? ??????? ???? ?????? ??????.
????? DBCC ????? '1'.
Msg 2570? ????? 16, ???? 3? ??? 1
?????? (1:154)? ??????? 0 ?? ???? ???? 2073058421? ???? ???? ????? 0? 72057594038321152 ????? ???? ????? ???? 72057594042318848 (??? "?? ?? ??????"). ?????? "col2" ???? ???? ???? ??? ???????? "?????". ????? ???? ????? ????? ???.
???? 4 ???? ?? ????? 2 ?????? "???? 1".
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ?????? 'table1' (???? ???? 2073058421).
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ????? ???????? '???????'. ?? ??????? DBCC. ??? ??? ??? ?? ????? DBCC ?????? ???? ?????? ??????.
????? DBCC ????? '2'.
Msg 2570? ????? 16, ???? 3? ??? 1
?????? (1:155)? ??????? 0 ?? ???? ???? 2105058535? ???? ???? ????? 0? 72057594038452224 ????? ???? ????? ???? 72057594042449920 (??? "?? ?? ??????"). ?????? "col2" ???? ???? ???? ??? ???????? "????". ????? ???? ????? ????? ???.
???? 4 ???? ?? ????? 1 ?????? "???? 2".
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ?????? '????' (???? ???? 2105058535).
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ????? ???????? '???????'. ?? ??????? DBCC. ??? ??? ??? ?? ????? DBCC ?????? ???? ?????? ??????.
DBCC ????? 'table3'.
Msg 2570? ????? 16, ???? 3? ??? 1
?????? (1:157)? ??????? 0 ?? ???? ???? 2121058592? ???? ???? ????? 0? 72057594038517760 ????? ???? ????? ???? 72057594042515456 (??? "?? ?? ??????"). ?????? "col2" ???? ???? ???? ??? ???????? "?????/???". ????? ???? ????? ????? ???.
???? 3 ???? ?? ????? 1 ?????? "table3".
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ?????? 'table3' (???? ???? 2121058592).
CHECKDB ?????? ??? ????? ??????? 0 ?????? ????? 1 ?? ????? ???????? '???????'. ?? ??????? DBCC. ??? ??? ??? ?? ????? DBCC ?????? ???? ?????? ??????.
?? ??? ??? ????? ?? ?? ????? ??? ???? ???? ??? ????? ??? 2570.

????? ????? ???? ????????

???? ????? ??????? 2570 ??????? ?? ????? DBCC ??????. ???? ???? ?? ???????? DBCC ?????? ?? ?? ?????? ??? ?? ?????? ???? ??? ???? ?????? ??? ????. ?????? ??? ?? ???? ???? ???? ????? ??????.

?????? ????? ????? ??? ???? ?????? ??? ???? ?? ???????. ???? ??????? ?????? ???.
  • ????? ??????? ????? ???? ????? ?????? ??? ??? ??? ????? ????? ?? ?????? ???? ????? ??? ????? ??? ?????.
  • ??????? ????????? ?? ??? 2570 ?????? ?????? ???? ????? ??? ???? ??? ?????.
??? ?????? ?? ?? ??? ???????? ???????? ?????? ??????? ????? ????? ?? ?????? ???? ????? ??? ?????? ??? ?????.

????? ??? ????? ???? ???? ?????? ?? ?????? ??????? ???? ???? ????????? ??????? ???????? ???????? ??? ?????. ??? ?????? ????? ?????? ???????? ??? ???? ??? ????? ???????? ????? ?? ?? ?????? ?????? ???? ???? ????? ?? ????????. ???? ?????????:
  • ??? ??? ???? ?? ?? ?????? ???? ??? ?? ????? ??????? ??? ?? ???? ?????.
  • ??????? ??? ???? ???????? ??????.
  • ????? ???? ?????? ??? ???? ?????.
  • ????? ???? ?????? ??? ???? ?????? ?? ???? ?????? ???? ?? ??? ?????? ??????.
  • ??? ??? ???? ??? ?? ??????? ???? ?? ???? ???? ????? ??????? ????? ??? ??? ???? ?????.

????? ?? ?????? ???? ????? ??? ??? ??? ????? ???????? ????????? T SQL

??? ????????? ???? ????? ??? ????? ????? ?? ?????? ???? ????? ??? ??? ??? ????? ????? ??? ??? ?????? ?????? ???? ??????? ?? ?????. ??? ???? ?? ????? ??????? ?????? 2570? ?????? ????? ????? ?? ????????? ???? ??? ?????? ???. ?? ?????? ??????? ?????? ?????? "account_name_japan" ??? ???? ???? ??? ???????? "nvarchar." ?????? ?????? ?????? ??? ?????? ???? ????? ??? ??????? ????? ??? ???????? ???? ???????. ?????? ??? ????? ????? ??? ???????? ???????? ????? ????? ??? ????????? ????? ?? ?????? ???? ????? ??? ??? ??? ????? ???? ????? ????? ??????? ?????? ???? (???????? ?? ???? where) ??? ?????? ????? ?? ???.

??? ?????? Unicode:
SELECT col1 ,DATALENGTH(account_name_japan) as Length ,account_name_japan 
FROM account_history
WHERE DATALENGTH(account_name_japan) % 2 != 0

??? ?????? ????:
-- Change col1 to your actual primary key column(s), col2 to the column from the 2570 error, table1 to the table from the CHECKDB output

SELECT col1, col2 FROM table1
WHERE col2<>0.0 AND (col2 < 2.23E-308 OR col2 > 1.79E+308) AND (col2 < -1.79E+308 OR col2 > -2.23E-308)

??? ???????? ????????:
-- Change col1 to your actual primary key column(s), col2 to the column from the 2570 error, table1 to the table from -- the CHECKDB output

SELECT col1, col2 FROM testReal 
WHERE col2<>0.0 AND (col2 < CONVERT(real,1.18E-38) OR col2 > CONVERT(real,3.40E+38)) AND (col2 < CONVERT(real,-3.40E+38) OR col2 > CONVERT(real,-1.18E-38)) 
ORDER BY col1; -- checks for real out of range
??????? ???????? ??? ????????:
SELECT col1 FROM table2
WHERE col2 > 9999999999.99999 
OR col1 < -9999999999.99999
?? ?? ??????? ?? ??? ????? ??? ??? ??? ???????? ????? ???????? ???? ?????? ???? ???? ?? ????. ?? ?????? ?????? ?? ????? ?????? ? decimal(15,5) ???? 2.

??????? ????? ???????? ???:
??? ????? ??? ????? ????????? ?????? ????? ?????? ?????? ???? ????? ??? ??? ?????? ??? ??????? ??? ????.
SELECT col1 FROM table3
WHERE col2 < '1/1/1753 12:00:00 AM' OR col2 > '12/31/9999 11:59:59 PM'

SELECT col1 FROM table3 WHERE
((DATEPART(ms,col2)+ (1000*DATEPART(s,col2)) + (1000*60*DATEPART(mi,col2)) + (1000*60*60*DATEPART(hh,col2)))/(1000*0.00333)) 
> 25919999

????? ?? ?????? ???????? ???? ??? ????? ???????? ?????? ??????:

????? ??????? ??? ??????? ??? ??? ??? ???? ??? ?????? ??? ???? ??????? ???? ?????? ??????? T SQL ???. ?? ????? ????? 2570? ??? ????? ?????? ?????? ???? ???? ????? ??? ?????? ??? ?????. ?? ??? ????? ???? ???? ??? ??????? ???????:
?????? (1:157) ?????? 0 ?? ???? ???? 2121058592? ???? ???? 0? ??? 72057594038517760 ????? ???? ????? ???? 72057594042515456 (????? "?? ?? ??????"). ???? ?????? "col2" ???? ???? ??? ???????? "?????/???". ????? ???? ??????? ????.
?? ??? ???????? ??? ????? ?????????: ?????? (1:157) ???? 0. ??? ?? ????????? ???? ????? ??? ????? ????. ????? ?? 1? ????????? 157? ? SlotId ?? 0. ?????? ???????? ?? ??? ?????????? ????? ????? ?????? ?????? ??? ???:
DBCC TRACEON ( 3604 )
DBCC PAGE ( realdata , 1 , 157 , 3 )
???? ????? ??? ????? ??????? ???? ???????. ???????? ???? ??????? DBCC ??????:
  • ??? ????? ????????
  • ?????
  • ?????????
  • ???? ???????
????? ????? ??? ?????? ?????? ??????? ???? ????? ??? ??????? ?????? ??????? ??????:
Slot 0 Offset 0x60 Length 19 Record Type = PRIMARY_RECORD Record
		  Attributes = NULL_BITMAP Memory Dump @0x44D1C060 00000000: 10001000 01000000
		  ffffffff ffffffff ?................ 00000010:
		  0200fc???????????????????????????????... Slot 0 Column 0 Offset 0x4 Length 4 col1 = 1Slot 0 Column 1 Offset 0x8 Length 8 col2 = Dec 31 1899 19:04PM Slot 1 Offset 0x73 Length 19 Record Type = PRIMARY_RECORD Record
		  Attributes = NULL_BITMAP Memory Dump @0x44D1C073 00000000: 10001000 02000000
		  0ba96301 f8970000 ?..........c..... 00000010:
		  0200fc???????????????????????????????... Slot 1 Column 0 Offset 0x4 Length 4
		  col1 = 2 Slot 1 Column 1 Offset 0x8 Length 8 col2 = Jul 8 2006 9:34PM Slot 2
		  Offset 0x86 Length 19 Record Type = PRIMARY_RECORD Record Attributes =
		  NULL_BITMAP Memory Dump @0x44D1C086 00000000: 10001000 03000000 0ba96301
		  f8970000 ?..........c..... 00000010: 0200fc???????????????????????????????...
		  Slot 2 Column 0 Offset 0x4 Length 4 col1 = 3 Slot 2 Column 1 Offset 0x8 Length
		  8 col2 = Jul 8 2006 9:34PM 
????? ?? ??? ??????? ?????? ??? ?????? ???? ??????? ?????. ?? ??? ??????? ????? ??? ?? ??????? ?? ???? 0 ?? ??????. ?? ????? ?????? ???? ?? ??? ???? 2 ????? ?? ???????. ??? ????? ?????? ??? ???? ?????? 1 ?????? 0 ????????? ????? ????? ?? ???? where ?? ??????? ??????? ?????? ?? ?? ???? ????.

????? ???? ???????? ??????? ?????? (??? ????? ??????? T SQL ????????? ?????? ??? ????????? ????????). ??????? ????? DBCC PAGE ??? ?????. ??????? ?????? ????? ??????? ??? ????? ?? ????? ????. ?? ???????? ??????? ????? ?????? ??????? ??? ?????? ?? ?????? ??? ???? ????????? ???????? ???????? ???? DBCC ??????? ?? ?? ?????? ????????? ??? ???? ???????. ??????? ??????? ???? ?? ???????? ????? ???????? ????? ?? ???? ???? ?? ??? ?????? ??? ?????? ??? ???? ????? ?? ????? ????????.

?????

?????? ??? ???? ?? ????????? ??? ????? DBCC CHECKDB? ???? ????? "CHECKDB DBCC (TRANSACT-SQL)" ?? Microsoft Developer ??????? ???? ???? ??????? (MSDN) ??? ???:
http://msdn2.microsoft.com/en-us/library/ms176064.aspx
????? ?? ????????? ??? ???????? ???????? ?? SQL Server 2000? ???? ??? ??? ??????? ?????? ?????? ??????? ?? "????? ??????? ? Microsoft":
900335?????: ????? ????????? ???????? ?????? ???????? SQL Server 2000 ?? ?? ???? ??? ??? ???? ????? ??? ??? ?????? ???? ?? ??? ?????? ??????? ???? ???????? ??? ????? ??? ???? ???
?????? ??? ???? ?? ????????? ??? ????? RPC? ???? ??????? ?????? "???????" ????? ???? "(OLE DB)" ??? ???? "msdn ??? ???" ???????:
.aspx http://msdn2.microsoft.com/en-us/library/aa198358 (SQL.80)
?????? ??? ???? ?? ????????? ??? ????? ?????? ??????? ???? ??????? ?????? "???????" ????? ???? "(OLE DB)" ??? ???? "msdn ??? ???" ???????:
http://msdn2.microsoft.com/en-us/library/ms187752.aspx
????? ?? ????????? ??? ???????? ???? ???? ?????? ?? ?????? ???? Intel ??? ??? ??????:
http://www.intel.com/design/pentiumii/manuals/243191.htm
Microsoft ????? ??????? ??? ??????? ?? ??? ?????? ???????? ?? ?????? ??? ????? ?????. ?? ????? ??????? ??????? ??? ???? ?????. Microsoft ??? ????? ???? ??? ??????? ??????? ?????? ???? ??????.

???????

???? ???????: 923247 - ????? ??? ??????: 29/???? ??????/1433 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Standard Edition for Small Business
????? ??????: 
kbtshoot kbexpertiseadvanced kbsql2005engine kbinfo kbmt KB923247 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????923247

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com