Lm th? no ? xc ?nh nguyn nhn ?a vo m?t s? ki?n SP:Recompile

D?ch tiu ? D?ch tiu ?
ID c?a bi: 308737 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

TM T?T

Bi t?ng b?c ny m t? lm th? no ? xc ?nh nguyn nhn ?a vo m?t SP:Recompile s? ki?n.

Xc ?nh nguyn nhn ?a vo m?t s? ki?n SP:Recompile

Cc SP:Recompile s? ki?n trong SQL Profiler ch? ra khi SQL Server bin m?t th? t?c ?c lu tr? ho?c m?t kch ho?t. Trong SQL Server 2000 Service Pack 2 (SP2) ho?c trong SQL Server 2005, cc SP:Recompile s? ki?n cung c?p thm thng tin v? l? do t?i sao ?a x?y ra, l h?u ch khi b?n ang g? r?i cc v?n ? recompile.

Khi SQL Server ch?y m?t th? t?c ?c lu tr? ho?c m?t kch ho?t, SQL Server c th? bin d?ch cc th? t?c ?c lu tr? ho?c kch ho?t l? do khc nhau. Cc SP:Recompile s? ki?n trong SQL Profiler cho th?y khi m?t th? t?c ?c lu tr? ho?c kch ho?t m?t ?c bin.

Trong SQL Server 2000 SP2 ho?c trong SQL Server 2005, cc SP:Recompile s? ki?n xc ?nh l? do ?a v?i m?t m? s? nguyn trong cc EventSubClass c?t. y l danh sch cc m? s? nguyn v?i nh?ng l? do cho ?a:

SQL Server 2000 SP2
   Integer code   Reason for recompilation
   -----------------------------------------------------------------------
   1              Schema, bindings, or permissions changed between compile
                  or execute.

   2              Statistics changed.

   3              Object not found at compile time, deferred check to 
                  run time.

   4              Set option changed in batch.

   5              Temp table schema, binding, or permission changed.

   6              Remote rowset schema, binding, or permission 
                  changed.
				
SQL Server 2005
   Integer code   Reason for recompilation
   -----------------------------------------------------------------------
   1  		  Schema changed.
               	  
   2  		  Statistics changed.
      		  
   3  		  Recompile DNR.
      		  
   4  		  Set option changed.
      		  
   5  		  Temp table changed.
      		  
   6  		  Remote rowset changed.
      		  
   7  		  For browse perms changed.
      		  
   8  		  Query notification environment changed.
      		  
   9  		  MPI view changed.
      		  
   10 		  Cursor options changed.
      		  
   11 		  With recompile option.
? bi?t thm thng tin v? cc SP:Recompile s? ki?n trong SQL Server 2005, xem cc ch? ? "SP:Recompile s? ki?n Class" trong SQL Server 2005 sch tr?c tuy?n.

THAM KH?O

? bi?t thm chi ti?t v? service pack m?i nh?t cho Microsoft SQL Server 2000, 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

Thu?c tnh

ID c?a bi: 308737 - L?n xem xt sau cng: 27 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • 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 Workgroup Edition
T? kha:
kbhowtomaster kbmt KB308737 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:308737

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