Kh?c ph?c: B?n nh?n ?c l?i 3624 v c s? d? li?u ng?i dng ?c nh d?u nghi ng? sau khi b?n th?c hi?n m?t ho?t ?ng chn s? l?ng l?n trong SQL Server 2000

D?ch tiu ? D?ch tiu ?
ID c?a bi: 825197 - Xem s?n ph?m m bi ny p d?ng vo.
L?i #: 469496 (SQL Server 8,0)
Bung t?t c? | Thu g?n t?t c?

? Trang ny

N?i dung bi vi?t

TM T?T

i?u ny bi vi?t m t? sau y v? b?n pht hnh hotfix ny:
  • Cc v?n ? ?c c? ?nh b?i hotfix ny gi
  • i?u ki?n tin quy?t cho vi?c l?p ?t cc hotfix gi
  • Cho d b?n ph?i kh?i ?ng l?i my tnh c?a b?n sau khi b?n ci ?t gi hotfix
  • Cho d cc gi hotfix ?c thay th? b?i b?t k? hotfix no khc gi
  • Cho d b?n ph?i th?c hi?n b?t k? thay ?i s? ng k?
  • Cc t?p tin ?c ch?a trong cc hotfix gi

TRI?U CH?NG

Khi b?n th?c hi?n m?t ho?t ?ng chn s? l?ng l?n trong Microsoft SQL Server 2000, giao d?ch t?p nh?t k? tr? thnh b? h?ng v l?i 3624 ?c vi?t l?i SQL Server ng nh?p. Sau , c s? d? li?u ng?i dng ?c nh d?u k? t?nh nghi. V d?, b?n ch?y chi?n d?ch chn s? l?ng l?n sau y:
DELETE FROM <tableName>

BULK INSERT TableName FROM 'FileName' WITH (DATAFILETYPE = 'native', TABLOCK)
Khi b?n lm i?u ny, b?n c th? nh?n ?c m?t thng bo l?i tng t? nh cc sau:
Ngay Gi spid55 Stack ch? k? cho cc b?i ch?a l 0x30BD6BDF
Ngay Gi spid55 SQL Server Kh?ng ?nh: T?p tin: <recbase.cpp>, d?ng = 1374 th?t b?i trong vi?c kh?ng ?nh = ' m_nVars > 0'.<b00></b00></recbase.cpp>
Ngay Gi spid55 L?i: 3624, m?c ? nghim tr?ng: 20, bang: 1.
Ngay Gi Phin b?n s? d?ng 'dbghelp.dll' spid55 '4.0.5' * Dump ch? ? - d?ch v? spid = 55, PSS = 0x3729d290, EC = 0x3729d5b8
i?u ny v?n ? x?y ra khi m?t ho?c nhi?u hn cc i?u ki?n sau l ng:
  • M?t ch? s? khng t?p trung vo b?ng t?n t?i.
  • M?t g?i ? truy v?n TABLOCK ?c s? d?ng.
  • B?ng khng ?c c?t ng?n tr?c khi b?n th?c hi?n s? l?ng l?n a vo ho?t ?ng.
  • DBCC DBREINDEX tuyn b? ? khng ?c s? d?ng ? xy d?ng l?i Danh m?c tr?c khi b?n th?c hi?n hng lo?t a vo ho?t ?ng.
? c m?t danh sch cc trang tr?c hotfixes, xem "Microsoft SQL Server 2000 post-Service Pack 3 ho?c Microsoft SQL Server 2000 post-Service Pack 3A hotfixes"ph?n trong bi vi?t c s? ki?n th?c Microsoft sau:
290211 Lm th? no ? c ?c SQL Server 2000 service pack m?i nh?t

NGUYN NHN

V?n ? ny x?y ra b?i v? m?t s? vi ph?m truy c?p x?y ra ?c gy ra b?i m?t kh?ng ?nh trong cc RecBase::ResizeVar ch?c nng. Vi ph?m truy c?p lm cho m?t ngo?i l? gy t? vong. Ngo?i l? gy t? vong nguyn nhn x? l? ngo?i l? ?t c s? d? li?u ng?i dng trong tr?ng thi nghi ng?.


GI?I PHP

D?ch v? gi thng tin

? gi?i quy?t v?n ? ny, c ?c gi d?ch v? m?i nh?t cho Microsoft SQL Server 2000. bit thm thng tin, bm vao s bai vit sau xem bai vit trong C s Kin thc Microsoft:
290211 Lm th? no ? c ?c SQL Server 2000 service pack m?i nh?t

Thng tin hotfix

iu kin tin quyt

B?n ph?i ci ?t SQL Server 2000 Service Pack 3 (SP3) p d?ng hotfix ny. ? bi?t thm chi ti?t v? lm th? no ? c ?c SQL Server 2000 Service Pack 3, nh?p vo s? bi vi?t sau y ? xem bi vi?t trong c s? ki?n th?c Microsoft:
290211Lm th? no ? c ?c SQL Server 2000 service pack m?i nh?t

Kh?i ?ng l?i thng tin

B?n khng ph?i kh?i ?ng l?i my tnh c?a b?n sau khi b?n p d?ng i?u ny hotfix.

Thng tin t?p tin hotfix

Hotfix ny ch?a ch? l nh?ng t?p tin ?c yu c?u ? s?a ch?a cc v?n ? c danh sch cc bi vi?t ny. Hotfix ny c th? ch?a t?t c? cc t?p b?n ph?i c ? hon ton C?p Nh?t m?t s?n ph?m m?i nh?t xy d?ng.

Phin b?n ti?ng Anh c?a hotfix ny c cc thu?c tnh t?p (ho?c sau ny t?p tin thu?c tnh) m ?c li?t k trong b?ng sau. Ngy thng v th?i gian cho nh?ng t?p tin ?c li?t k trong gi? ph?i h?p qu?c t? (UTC). Khi b?n xem chi tiet tap tin, n ?c chuy?n ?i thnh gi? c?c b?. ? bi?t s? khc nhau gi?a UTC v local time, s? d?ng cc Mi gi? th? cng c? ngy v gi? trong Pa-nen i?u khi?n.
  Date         Time   Version        Size       File name
  ------------------------------------------------------------------
  31-May-2003  19:45  2000.80.818.0     78,400  Console.exe      
  25-Jun-2003  02:01  2000.80.818.0     33,340  Dbmslpcn.dll     
  25-Apr-2003  03:12                   786,432  Distmdl.ldf
  25-Apr-2003  03:12                 2,359,296  Distmdl.mdf
  30-Jan-2003  02:55                       180  Drop_repl_hotfix.sql
  23-Jun-2003  23:40  2000.80.837.0  1,557,052  Dtsui.dll        
  23-Jun-2003  23:40  2000.80.837.0    639,552  Dtswiz.dll       
  24-Apr-2003  03:51                   747,927  Instdist.sql
  03-May-2003  02:56                     1,581  Inst_repl_hotfix.sql
  08-Feb-2003  07:40  2000.80.765.0     90,692  Msgprox.dll      
  01-Apr-2003  03:07                     1,873  Odsole.sql
  05-Apr-2003  02:46  2000.80.800.0     62,024  Odsole70.dll     
  07-May-2003  21:41  2000.80.819.0     25,144  Opends60.dll     
  02-Apr-2003  22:48  2000.80.796.0     57,904  Osql.exe         
  03-Apr-2003  00:15  2000.80.797.0    279,104  Pfutil80.dll     
  22-May-2003  23:57                    19,195  Qfe469571.sql
  11-Jul-2003  18:04                 1,084,147  Replmerg.sql
  04-Apr-2003  22:53  2000.80.798.0    221,768  Replprov.dll     
  08-Feb-2003  07:40  2000.80.765.0    307,784  Replrec.dll      
  11-Jul-2003  17:56                 1,085,925  Replsys.sql
  01-Jun-2003  02:01  2000.80.818.0    492,096  Semobj.dll       
  31-May-2003  19:27  2000.80.818.0    172,032  Semobj.rll
  29-May-2003  01:29                   115,944  Sp3_serv_uni.sql
  01-Jun-2003  02:01  2000.80.818.0  4,215,360  Sqldmo.dll       
  07-Apr-2003  18:44                    25,172  Sqldumper.exe    
  19-Mar-2003  19:20  2000.80.789.0     28,672  Sqlevn70.rll
  02-Jul-2003  01:18  2000.80.834.0    180,736  Sqlmap70.dll     
  08-Feb-2003  07:40  2000.80.765.0     57,920  Sqlrepss.dll     
  10-Jul-2003  23:00  2000.80.840.0  7,553,105  Sqlservr.exe     
  08-Feb-2003  07:40  2000.80.765.0     45,644  Sqlvdi.dll       
  25-Jun-2003  02:01  2000.80.818.0     33,340  Ssmslpcn.dll     
  01-Jun-2003  02:01  2000.80.818.0     82,492  Ssnetlib.dll     
  01-Jun-2003  02:01  2000.80.818.0     25,148  Ssnmpn70.dll     
  01-Jun-2003  02:01  2000.80.818.0    158,240  Svrnetcn.dll     
  31-May-2003  19:59  2000.80.818.0     76,416  Svrnetcn.exe     
  01-May-2003  00:52  2000.80.816.0     45,132  Ums.dll          
  02-Jul-2003  01:19  2000.80.834.0     98,816  Xpweb70.dll      
Chu y V? c?a t?p tin ph? thu?c, hotfix g?n y nh?t m ch?a cc t?p tin c?ng c th? ch?a t?p b? sung.

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".V?n ? ny l?n ?u tin ? ?c s?a ch?a trong Microsoft SQL Server 2000 Service Pack 4.

THNG TIN THM

? c thm thng tin v? gi?n ? ?t tn cho SQL Server C?p Nh?t, b?m s? bi vi?t sau y ? xem bi vi?t trong c s? ki?n th?c Microsoft:
822499Gian t tn mi danh cho cac goi cp nht phn mm Microsoft SQL Server
? bi?t thm chi ti?t v? thu?t ng? m Microsoft s? d?ng khi n s?a ch?a ph?n m?m sau khi n ?c pht hnh, nh?p vo s? bi vi?t sau y ? xem bi vi?t trong c s? ki?n th?c Microsoft:
824684M t? cc thu?t ng? tiu chu?n ?c s? d?ng ? m t? C?p nh?t ph?n m?m Microsoft

Thu?c tnh

ID c?a bi: 825197 - L?n xem xt sau cng: 29 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Workgroup Edition
T? kha:
kbhotfixserver kbqfe kbsqlserv2000presp4fix kbbug kbfix kbmt KB825197 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:825197

Cung cp Phan hi

 

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