FIX: ??? ???? DTS ??? ??? ???????? BLOB ???? ?? 64 ???? ????

?????? ????????? ?????? ?????????
???? ???????: 257425 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 53859 (sqlbug_70)
????? ???? | ?? ????

???????

???? "??? ???? ????? ????? ????????" (DTS) ?? ?? ??? ????? ??? ?????? ???? ???? ????? (BLOB) ??? ??? ???? ???? ?? 64 ???? ???? ?? ???????? ?? ?? ?? ?? ???? ?? ?? ntext ?? ?????? ?? ????? ?????? ??? DTS.

????? ??????? ???? ?? ?????:
  • ?????? ??? ?????? ?? ??????????? ??????.
  • ?? ????? ????? ??????? ???? SQL (SEM) ?? ????????? (???? ?????).
  • ??? ?????? ??? ?????.
  • ?? ??? ???????? ???????? ????????.

?????

?????? ???? ??? ???? SQL ??????? ????? ???????? (SQL-DMO) ?????? ?????. ?? ??? ????? DMO ??? ???? ?? 64 ???? ???? ?? ???????? BLOB ??? ???.

???? ??????

?? ??? ?????? ????? ?????? ?? ????? ?????????/??????? DTS??? ???????? ??? ????? ?????? SQL Server 7.0 ?????????. ???? ??????? ??????? ?? ??? "???????" ? ?????? ?????? ??? ???? (?????) ?? ????? ?????? ?????? ?????? ?? ????? ????? ?? ?? ?? ntext ?? ?????? ??????.

?? ???? ?? ??????? "???? ?????" ??? ??? ?????? ??????? ???????? ????? ?? ?? ???????? ?????? ??? ???? (?????) ?? ????? ???????? ?????? ??? ??? ???????? (??????? ??? ?? ??? ??? ????? ???? ????????? ?????? ?????? ??????). ???? ?????? ???? ?? ?????? ????? ???? ???????? ??? ???????? ?? ??????? ??? ??????? ????? "??? ????" ??? ???????.

?????? ??????? ?? ????? ???????? ?????? ???? ????? ??? ?? ?? ntext ?? ????? ??? ?? ???? ??? ??????? ??? ????? ????????? ??????:
   USE <source database name>
   GO
   SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
   WHERE DATA_TYPE IN ('text', 'ntext', 'image')
				

?????

???? Microsoft ??? ???? ????? ?? SQL Server 7.0. ?? ????? ??? ??????? ?? ???????? ??????? Service Pack 1 ?? Microsoft SQL Server 7.0. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
232570INF: ????? ?????? ??? ???? ?????? Service Pack 1 ?? Microsoft SQL Server 7.0 ? ???? ??????? Microsoft (MSDE) 1.0
????? ?? ?????????? ???? ????? ????? ???????.

??????? ????

??? ??? ??? ????????? ???? ???? ?????? ????? ??????? (SEM) SQL Server 7.0 ?????? ????? ?????? Service Pack 1 ?? ????? ???? ?????? ??? ?? ?? ????? ?????? ??? ?????? ?? ???????? SEM ????? ?? ????????? ?? ????? ???? ??? ????? ????? ????? ??? ???????? BLOB ???? ?? 64 ???? ????. ??? ???? ?????? ????? DMO ????? ?? ???? ??? ???? ??? BLOB 64 ?.? ??? ?????? ???????? ntext ?????? ????? ???? ?? 64 ???? ???? ?? 64000 ???? ?? ????? ???????? ??????. ??? <server>. < ????? ?????? ?????? > ?????? .LOG ?? ???? ????? ??? ?? ?????? ????:
  ::Error::
  Transfer Status: Transferring Data: (Table '[dbo].[bigtext]')
    Data truncation occurred in table [dbo].[bigtext], column 2.

					
?????? ?? ?????? GUI ??? ??????? ??? ??? ??? ??? ?????? ??????:
??? ???????? ????? ?? Microsoft SQL Server "??? Microsoft SQL Server.
??? DMO ?? SQL Server 2000 (?? ??? ???? ?? DTS) ??? ???? 8 ???????? ?? ???. ??? ?????? ??? ???? ???? ?? 8 ???????? ??? ??? DTS ?? ???? ????? ????? ???:
??? ?? ??? ???????? ?? Microsoft SQL Server ??? Microsoft SQL Server.
??? ???? ????? ??????? ??? ?????? ??????? ?? ???? ?????? ????? ???? (??? ?????? ???? SQL) ???? ????? ????? ???:
[SQL DMO]??? ????? "??? ????".

???????

???? ???????: 257425 - ????? ??? ??????: 14/???/1427 - ??????: 2.1
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbbug kbfix KB257425 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????257425

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

 

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