FIX: ???? ???? ???? ??????? ??? ??????? ??????? sp_OAMethod ????? ?? ????? sp_OAGetProperty ????? ??????? ????? ????? COM ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 937277 - ??? ???????? ???? ????? ????? ??? ???????.
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

?? Microsoft SQL Server 2005 ??? ??????? ????? ????? (COM) "???? ???? ?????? ???????? ??????? sp_OAMethod ????? ?? ????? sp_OAGetProperty ????? ???? ??????? ????. ??????? ??? ??????? sp_OAMethod ????? ???? ??? ??????? ??? ??? ??????? ????? ??????? ?? ????? ??????? ???????. ??????? ??? ??????? sp_OAGetProperty ????? ???? ??? ??????? ??? ??? ??????? ?????? ????? ???? ????? ?? ????? ?????.

???????? ??? ???? ??? ?????? ???? ??????? ????? ??????? ???? exhausts ?????? - ??? ? ??? ????? ????? ????? ??????? ?? ??? ??? ??????? SQL Server:
01 ???? 2008 08:35:07.80 spid535 Downgrading ????? ????????? ??????? ?? 1024K ??? 64 ???? ????
??? spid77 09:35:22.55 ? ???? ???? ??????? ????? ??????: FAIL_VIRTUAL_RESERVE 1048576
??? spid593 10:48:04.85 ? ???? ????: 701 ? ???????: ???? 17 ?: 123.
? ???? ???? 10:48:04.85 spid593 ????? ?????? ??? ????? ?????? ??? ?????????.

?????

???? ??? ??????? ????? ??? ?? SQL Server 2005 ?????? ??????? ???? ?? ??????? ??? ????? ???? ????? ??? ???? ????? ?????.

????

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

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 2. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
936305???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2
??? ????? ????????? ??????? Microsoft SQL Server 2005 ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? SQL Server 2005 ?????? ????? ?????? SP2. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

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

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

??? ?? ???? ???? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ????? ????? ??? ??????? ??????.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??????? ?????? ??? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2232.069,488?????? ???? ????19: 36x 86
Databasemailengine.dll9.0.2232.075,120?????? ???? ????19: 36x 86
Logread.exe2005.90.2232.0400,752?????? ???? ????19: 37x 86
Microsoft.analysisservices.adomdclient.dll9.0.2232.0546,160?????? ???? ????19: 37x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2232.0140,656?????? ???? ????19: 37x 86
Microsoft.analysisservices.dll9.0.2232.01,217,904?????? ???? ????19: 37x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2232.078,192?????? ???? ????19: 37x 86
Microsoft.sqlserver.sqlenum.dll9.0.2232.0910,704?????? ???? ????19: 37x 86
Msasxpress.dll9.0.2232.024,944?????? ???? ????19: 37x 86
Msgprox.dll2005.90.2232.0200,560?????? ???? ????19: 37x 86
Msmdlocal.dll9.0.2232.015,646,064?????? ???? ????19: 37x 86
Msmdredir.dll9.0.2232.03,993,968?????? ???? ????19: 37x 86
Odsole70.dll2005.90.2232.059,760?????? ???? ????19: 37x 86
Qrdrsvc.exe2005.90.2232.0369,520?????? ???? ????19: 37x 86
Rdistcom.dll2005.90.2232.0643,440?????? ???? ????19: 37x 86
Repldp.dll2005.90.2232.0187,248?????? ???? ????19: 37x 86
Replmerg.exe2005.90.2232.0320,880?????? ???? ????19: 37x 86
Replprov.dll2005.90.2232.0550,256?????? ???? ????19: 37x 86
Replrec.dll2005.90.2232.0784,752?????? ???? ????19: 37x 86
Replsub.dll2005.90.2232.0407,408?????? ???? ????19: 37x 86
Spresolv.dll2005.90.2232.0177,008?????? ???? ????19: 37x 86
Sqlaccess.dll2005.90.2232.0350,576?????? ???? ????19: 37x 86
Sqlagent90.exe2005.90.2232.0321,392?????? ???? ????19: 37x 86
Sqlservr.exe2005.90.2232.028,979,112?????? ???? ????19: 37x 86
Sqsrvres.dll2005.90.2232.066,416?????? ???? ????19: 37x 86
Xmlsub.dll2005.90.2232.0195,440?????? ???? ????19: 37x 86
Xpstar90.dll2005.90.2232.0295,280?????? ???? ????19: 37x 86
Xpstar90.rll2005.90.2232.0155,504?????? ???? ????19: 37x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2232.088,944?????? ???? ????16: 46x 64
Databasemailengine.dll9.0.2232.075,120?????? ???? ????16: 46x 86
Logread.exe2005.90.2232.0525,168?????? ???? ????16: 46x 64
Microsoft.analysisservices.adomdclient.dll9.0.2232.0546,160?????? ???? ????16: 46x 86
Microsoft.analysisservices.adomdclient.dll9.0.2232.0546,160?????? ???? ????19: 37x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2232.0140,656?????? ???? ????19: 37x 86
Microsoft.analysisservices.dll9.0.2232.01,217,904?????? ???? ????19: 37x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2232.094,064?????? ???? ????16: 46x 64
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2232.078,192?????? ???? ????19: 37x 86
Microsoft.sqlserver.sqlenum.dll9.0.2232.0877,936?????? ???? ????16: 46x 86
Msasxpress.dll9.0.2232.030,064?????? ???? ????16: 46x 64
Msasxpress.dll9.0.2232.024,944?????? ???? ????19: 37x 86
Msgprox.dll2005.90.2232.0262,000?????? ???? ????16: 46x 64
Msmdlocal.dll9.0.2232.015,646,064?????? ???? ????19: 37x 86
Msmdredir.dll9.0.2232.03,993,968?????? ???? ????19: 37x 86
Odsole70.dll2005.90.2232.090,992?????? ???? ????16: 46x 64
Qrdrsvc.exe2005.90.2232.0434,032?????? ???? ????16: 46x 64
Rdistcom.dll2005.90.2232.0836,464?????? ???? ????16: 46x 64
Repldp.dll2005.90.2232.0237,936?????? ???? ????16: 46x 64
Repldp.dll2005.90.2232.0187,248?????? ???? ????19: 37x 86
Replmerg.exe2005.90.2232.0417,648?????? ???? ????16: 46x 64
Replprov.dll2005.90.2232.0747,888?????? ???? ????16: 46x 64
Replrec.dll2005.90.2232.01,010,544?????? ???? ????16: 46x 64
Replsub.dll2005.90.2232.0528,240?????? ???? ????16: 46x 64
Spresolv.dll2005.90.2232.0225,648?????? ???? ????16: 46x 64
Sqlaccess.dll2005.90.2232.0357,744?????? ???? ????16: 46x 86
Sqlagent90.exe2005.90.2232.0392,560?????? ???? ????16: 46x 64
Sqlservr.exe2005.90.2232.039,373,168?????? ???? ????16: 46x 64
Sqsrvres.dll2005.90.2232.078,192?????? ???? ????16: 46x 64
Xmlsub.dll2005.90.2232.0319,856?????? ???? ????16: 46x 64
Xpstar90.dll2005.90.2232.0543,600?????? ???? ????16: 46x 64
Xpstar90.rll2005.90.2232.0156,016?????? ???? ????16: 46x 64

?????

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

?????

????? ?? ????????? ??? ??? ??????? ?? Microsoft SQL Server 2000 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
816937FIX: ???? ???? ??????? ?? ???? ??? ??????? ??????? sp_OAMethod ??????? ?? ??????? ????? ????? COM
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

??????? ????

?? ???????? ????? ???????? ?????? ??????? ??????? sp_OAMethod ????? ?????? sp_OAGetProperty ????? ?????? ??? ??????? ???????? ????? ?????. If you run this script repeatedly on a new connection to SQL Server 2005, a memory leak occurs every time.
DECLARE @object int;
DECLARE @hr int;
DECLARE @src varchar(255), @desc varchar(255);
EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT;
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
RETURN 
END
EXEC @hr = sp_OASetProperty @object, 'LoginSecure', 'TRUE'
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
EXEC @hr = sp_OAMethod @object, 'Connect', NULL, '<ComputerName>\<InstanceName>'
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
DECLARE @property varchar(255)
EXEC @hr = sp_OAMethod @object, 'HostName', @property OUT
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
PRINT @property
EXEC @hr = sp_OAGetProperty @object, 'HostName', @property OUT
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
PRINT @property
EXEC @hr = sp_OADestroy @object
IF @hr <> 0 BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
???????? ??? ???? ?? ????? ???? ?????? ???? ??? ???? ??????? ??????? ?? ??? "???????". ?????? ??? ??? ??????? SQL ????????? ???????: ?????
2008-03-24 10:03:09.51 spid51      Using 'odsole70.dll' version '2005.90.1399' to execute extended stored procedure 'sp_OACreate'. This is an informational message only; no user action is required.
2008-03-24 10:03:13.43 spid51      Using 'dbghelp.dll' version '4.0.5'
2008-03-24 10:03:13.51 spid51      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump0001.txt
2008-03-24 10:03:13.53 spid51      SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2008-03-24 10:03:13.53 spid51      * *******************************************************************************
2008-03-24 10:03:13.53 spid51      *
2008-03-24 10:03:13.53 spid51      * BEGIN STACK DUMP:
2008-03-24 10:03:13.53 spid51      *   03/24/08 10:03:13 spid 51
2008-03-24 10:03:13.53 spid51      *
2008-03-24 10:03:13.54 spid51      *
2008-03-24 10:03:13.54 spid51      *   Exception Address = 0000000033387164 Module(odsole70+0000000000007164)
2008-03-24 10:03:13.54 spid51      *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
2008-03-24 10:03:13.54 spid51      *   Access Violation occurred reading address 0000000006264FF8
??? ????? ??? ??????? ?? ??? Odsole70.dll. ?? ??????? ????? ????? ??????? 2005.90.2232.0.

?? ????? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 2 (SP2) ??? ????? ?????. ?? ???? ?????? ??? ??????? ?? SQL Server 2005 ?????? ????? ?????? SP2 ??? ????? ????? ?????? ?????? ??? ???????.

??????? ???????? ????? ???? ????? ??? ??????? ???? ??????? ???????? 2 ?? SQL Server 2005 ?????? ????? ?????? SP2. ??? ????? ??? ??????? 09.00.3175. ????? ???? ????? ??? ????? ?????? ?? SQL Server 2005 ?? ?? ????? ?????? ?? ?? ?????? ??? ????? ???? ??? ??? ???????.

?????? ??? ???? ?? ????????? ??? ????????? ????????? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
937137???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP2

???????

???? ???????: 937277 - ????? ??? ??????: 10/?????/1429 - ??????: 4.0
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
????? ??????: 
kbmt kbautohotfix kbhotfixserver kbfix kbexpertiseadvanced kbqfe kbpubtypekc KB937277 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????937277

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

 

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