Tai n?n x?y ra khi b?n g?i th? t?c t? ?ng ha t? CLR ?i t?ng trong SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, v SQL Server 2012

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

Tri?u ch?ng

Gi? s? r?ng b?n ang ch?y Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2 ho?c Microsoft SQL Server 2012.B?n g?i m?t s? th? t?c t? ?ng ha t? m?t SQL Server ph? bi?n ngn ng? th?i gian ch?y (CLR) v?t, v d? nh sp_OACreate. Trong t?nh hu?ng ny, SQL Server c th? s?p ? b?t ng?. Ngoi ra, m?t thng bo l?i tng t? nh sau ?c ghi nh?t k? s? ki?n ?ng d?ng:

Thng tin <Time stamp=""></Time>Bo co 1001 khng c c?a s? l?i
L?i thng, nh?p 0
Tn s? ki?n: APPCRASH
Ph?n ?ng: Khng c
Cab Id: 0

V?n ? ch? k?:
P1: sqlservr.exe
P2: 2009.100.4000.0
P3: 4fecc5ba
P4: StackHash_b620
P5: 6.1.7601.17725
P6: 4ec4aa8e
P7: c0000374
P8: 00000000000c40f2
P9:
P10:

Lu ?V?n ? ny c?ng x?y ra khi m?t ?i t?ng CLR g?i l m?t th? t?c Transact-SQL cho cc cu?c g?i th? t?c t? ?ng ha.

Cch gi?i quy?t khc

? lm vi?c xung quanh v?n ? ny, khng ph?i tr?c ti?p ho?c gin ti?p c th? g?i th? t?c t? ?ng ha t? b?t k? ?i t?ng SQL Server CLR.

Thng tin thm

Khi m?t ?ng d?ng g?i th? t?c t? ?ng ha, m?t tin th thoai tng t? nh sau y ?c k nh?p trong SQL Server log:

<Time stamp=""></Time> Phin b?n b?ng cch s? d?ng 'odsole70.dll' spid365 '2009.100.1600' ? th?c hi?n m? r?ng th? t?c d?ch s?n 'sp_OACreate'. y l m?t bi vi?t thng tin khng c hnh ?ng ng?i dng ?c yu c?u.

Khi m?t ?ng d?ng g?i cho SQL Server CLR, m?t tin th thoai tng t? nh sau y ?c k nh?p trong SQL Server log:

<Time stamp=""></Time> spid313 ch?c nng th?i gian ch?y (CLR) ngn ng? ph? bi?n ?c kh?i t?o b?ng cch s? d?ng CLR Phin b?n v2.0.50727 t? <%windir%>\Microsoft.NET\Framework64\v2.0.50727\.

Lu ?Th tr?c khng cho th?y r?ng ?i t?ng CLR g?i th? t?c t? ?ng ha.

T?nh tr?ng

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

Thu?c tnh

ID c?a bi: 2796944 - L?n xem xt sau cng: 10 Thang Ging 2013 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2012 Enterprise
T? kha:
kbsurveynew kbtshoot kbexpertiseadvanced kbmt KB2796944 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: 2796944

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