FIX: ??? "?????? ??? ??? ?????" ?? ???? ??? ??????? ???? CONTAINSTABLE ?? OR ????? ????????? AND ?? SQL Server 2008 ?? ?? R2 2008 ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 2344600 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft ????????? Microsoft SQL Server 2008 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.???? Microsoft Microsoft SQL Server 2008 ?? ????? R2 2008 ???? SQL ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ?? R2 2008 ???? SQL ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ???? ??????? ??? ???? ?????? ???? ??????containstable????? ?? ??????????????? ??????? ?? ????? ?? Microsoft SQL Server 2008 ?? ?? R2 2008 ???? SQL. ??? ???? ??????? ???? 50 ???????????????:
    Declare @Keywords varchar(4000) = NULL
    
    set @Keywords= N'((((((((((((((((((((((((((((((((((((((((((((((((((((
    ("TOKarchitect" OR "architectural") 
    AND ("TOKengineer" OR "engineer")) 
    AND "gineer") AND ("TOKmechanical" OR "Mechanical")) 
    AND ("TOKengineer" OR "Engineering")) 
    AND ("TOKelectronic" OR "Electronics")) AND ("TOKengineer" OR "Engineer")) AND ("TOKelectronic" OR "Electronics")) AND ("TOKengineer" OR "Engineering")) AND ("TOKelectric" OR "Electrical")) AND ("TOKengineer" OR "Engineer")) AND ("TOKelectric" OR "Electrical")) AND ("TOKengineer" OR "Engineering")) AND ("TOKcontrol" OR "Control")) AND ("TOKsystem" OR "Systems")) AND ("TOKengineer" OR "Engineer")) AND ("TOKproject" OR "Project")) AND ("TOKmanager" OR "Manager")) AND ("TOKengineer" OR "Engineering")) AND "Scheme") AND ("TOKmanufacture" OR "Manufacturing")) AND ("TOKengineer" OR "Engineer")) AND ("TOKmetallurgist" OR "Metallurgy")) AND ("TOKmetallurgist" OR "Metallurgist")) AND ("TOKprocess" OR "Process")) AND ("TOKTechnology" OR "Technology")) AND ("TOKproduct" OR "Production")) AND ("TOKengineer" OR "Engineer")) AND ("TOKQuality" OR "Quality")) AND ("TOKengineer" OR "Engineer")) AND ("TOKQuality" OR "Quality")) AND ("TOKcontrol" OR "Control")) AND ("TOKengineer" OR "Engineer")) AND "Mechatronics") AND ("TOKcivil" OR "Civil")) AND ("TOKengineer" OR "Engineer")) AND ("TOKcivil" OR "Civil")) AND ("TOKengineer" OR "Engineering")) AND ("TOKdesign" OR "Design")) AND ("TOKengineer" OR "Engineering")) AND ("TOKdesign" OR "Design")) AND ("TOKengineer" OR "Engineer")) AND ("TOKgraduate" OR "Graduate")) AND ("TOKengineer" OR "Engineer")) AND ("TOKgraduate" OR "Graduate")) AND ("TOKengineer" OR "engineering")) AND ("TOKengineer" OR "Engineering")) AND ("TOKgraduate" OR "Graduate")) AND ") ANDNOT (") AND ("TOKRecruitment" OR "Recruitment")) AND ("TOKconsultant" OR "consultant")) AND ("TOKtrainee" OR "trainee")) AND ("TOKRecruitment" OR "recruitment"))'
    
    select * from CONTAINSTABLE(test_table, *, @keywords, 1000) 
  • ?? ?????? ?????????.
?? ??? ?????????? ?? ???? ??? "?????? ??? ??? ?????". ???????? ??? ???? ??? ????? ??? mini-dump ?? ???? ????? SQL Server 2008 ?? SQL Server 2008 R2 ???????? ???? ????? ????? ?????? ?? ??? ??? ??? ???? SQL:
<time stamp=""></time>?????? ???????? ????? 'dbghelp.dll' ' 4.0.5 '
<time stamp=""></time>???? *** ???? ?????? ??? ???? ???? ??????? spid 0
<time stamp=""></time>?????? *
*******************************************************************************
<time stamp=""></time>?????? *
<time stamp=""></time>?????? * ????? ?????? BEGIN:
<time stamp=""></time>?????? *<time></time>spid<spid></spid>
<time stamp=""></time>?????? *
<time stamp=""></time>* ???? ???? ?????? ??? ?????
<time stamp=""></time>?????? *
<time stamp=""></time>?????? *
*******************************************************************************
<time stamp=""></time>?????? ?? ????? ?????? ?????? ??? 0x000000000000030D
<time stamp=""></time>???? ????? ????? ???????? ?????? ??? 0x20000001. ????? ????? ???????? ?????? ??? ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel ???? ????? 62,% ms. 98 ??????? ????? 75187 ????????. ???? ?????? 0%. ?????? ??????: 76403 ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel 125 ???? ?????? ????????% ms. 98 ??????? ????? 145250. ???? ?????? 0%. ?????? ??????: 148417 ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel 171 ?????? ????????% ms. 98 ??????? ????? 205515. ???? ?????? 0%. ?????? ??????: 209729 ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel 218 ???? ?????? ????????% ms. 98 ??????? ????? 266343. ???? ?????? 0%. ?????? ??????: 271588 ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel 234 ???? ?????? ????????% ms. 97 ??????? ????? 325156. ???? ?????? 0%. ?????? ??????: 333671 ?????.
<time stamp=""></time>?????? ?????? 0: 0: 0 (0xf94) ???? 0x00000000817481A0 ???? ???-?????? ??? ????? 0. ???? ??????? ??? ???????: 12925321224306. ?????? ???? ??????? Approx ???? ???????? ????????: kernel 296 ???? ?????? ????????% ms. 97 ??????? ????? 386000. ???? ?????? 0%. ?????? ??????: 396370 ?????.

?????

???? ??? ??????? ??? SQL Server 2008 ?? R2 2008 ???? SQL ?? ????? ????? ???? ????.

????

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

SQL Server 2008 R2

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 5 ??????? ????????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? R2 2008 ???? SQL? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2438347???? ??????? ???????? 5 ? R2 2008 ???? SQL
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? R2 2008 ???? SQL ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
981356???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? R2 2008 ???? SQL

SQL Server 2008 Service Pack 1

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 10 ??????? ???????? ????? ?????? Service Pack 1 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2279604???? ??????? ???????? 10 ? SQL Server 2008 Service Pack 1
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
Microsoft SQL Server 2008 ????????? ??????? ??? ????? ??? ????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 1 ??? ????? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????????? ???????? ?? ???? ???? SQL Server ?? ???? ???? ? SQL Server ???????.

SQL Server 2008 Service Pack 2

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2289254??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2402659???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 2

???? ??????

??? ??? ???????? ?? ???????? ????? ??????? ??? ?? ???? ?????? ????????? ?? ???? ???????.

?????? ????? ??????formsof???? ??????? ??????????????? ?? ?? ?????? ???? ??????? ???????? ???????.

??? ???? ?????? ?????? ?? ??? "?????? ?????"? ?????? ????? ???? ?? ????? ?????????:
Select * from test_table where Contains(*,'FORMSOF (THESAURUS,"architectural","engineer","Mechanical","Engineering","Electronics","Engineer","Electrical","Control","Systems","Project","Manager","Manufacturing","Metallurgy","Metallurgist","Process",?Design?,"Technology","Production","Quality","Control","Civil","Graduate","Recruitment","consultant","trainee","recruitment")')

?????

???? Microsoft ?? ??? ??????? ???? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

?????

?????? ??? ???? ?? ????????? ???containstable????? ?? ?????? ???? ??? ???? ????? ???? Microsoft (MSDN) ???????:
??????? ???? ??? ???? CONTAINSTABLE
?????? ??? ???? ?? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897????? ????? ?????? ????? ?? ?????? SQL Server ?????? ????????? ??????? ??????? ???? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ?????? ??????? ??????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ????? ???? ??????? ????? Microsoft SQL Server
?????? ??? ???? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 2344600 - ????? ??? ??????: 14/????/1432 - ??????: 5.0
????? ???
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Service Pack 1
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
????? ??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2344600 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2344600

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

 

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