FIX: "???? ?????" ?? ?????? ??????? ??? ??????? ??? ?? ???? ????? "???? ???????" ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 934188 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50000952 (??????? ?????? SQL)
????? ???: 50000686 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

???????

?? Microsoft SQL Server 2005 ?? ???? "???? ?????" ???? ??? "???? ?????" ?? ?????? ??????? ??? ???????. ?? ???? ??? ??????? ??? ?? ???? ????? "???? ???????". ??? ????? "???? ?????" ??? ??????, ?? ??????? "???? ?????" ??????. ??? ????? ????? "???? ???????". ????? ?? ???? ??? ?? ???? ???? ???????? ???? ????? ??? ???? ????? ?????? (SPID) ????? ???????.

???? ??? ??????? ?? ???? ????? "???? ?????" ???????? ??? ?????? ????????. ????? ?????? ???? ?? ???? ????? ????? SubscriptionStreams ??? ???? ???? ?? 1.

??? ???? ??? ???????? ?? ??? ????? ???? SPID ????? ????? ??????? ?????? ??? ??? ??? ??????? ???? ?????.
select spid, blocked, lastwaittype from master..sysprocesses 
where '~280~~1336~~1853~~2702~' like '%~' + cast (spid as nvarchar)+ '~%' 
and '~280~~1336~~1853~~2702~' like '%~' + cast (blocked as nvarchar)+ '~%'

?????

???? ??? ??????? ???? ????? ?? ???? ????? ???? ????? ?? "???? ???????". ??? ??? ??? ?????? ??????? ?????? ?????? ??? ???? ??????? ??? ????? ??????? ???????? ????? ???????? ???? ????? ???? ????? ????? ????? ??????? ???????? ????? ????????.

????

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

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

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

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

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

  • SQL Server 2005 ?????? ????? ?????? Service Pack 2

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

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3154.0296,30410 ???? ??????: ??x 86
Mssqlsystemresource.ldf??? ???? ???????524,28810 ???? ????02: 59??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,56810 ???? ????02: 59??? ???? ???????
Rdistcom.dll2005.90.3154.0644,46410 ???? ??????: ??x 86
Msmdlocal.dll9.0.3154.015,930,22410 ???? ??????: ??x 86
Sqlaccess.dll2005.90.3154.0350,57610 ???? ??????: ??x 86
Sqlservr.exe2005.90.3154.029,191,53610 ???? ??????: ??x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3154.0296,30410 ???? ??????: ??x 86
Mssqlsystemresource.ldf??? ???? ???????524,28810 ???? ????02: 59??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,56810 ???? ????02: 59??? ???? ???????
Rdistcom.dll2005.90.3154.0828,27210 ???? ????11: 12x 64
Msmdlocal.dll9.0.3154.015,930,22410 ???? ??????: ??x 86
Sqlaccess.dll2005.90.3154.0357,74410 ???? ????11: 12x 86
Sqlservr.exe2005.90.3154.038,655,34410 ???? ????11: 12x 64

???? ??????

??????? ?????? ??? ??? ??????? ?????? ??? ???????? ???????:
  • ????? ????? ???? "???? ???????".
  • ????? ???? ??????? SubscriptionStreams ??? 1. ?????? ??? ???? ?? ????????? ??? ????? SubscriptionStreams ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
    http://msdn2.microsoft.com/en-us/library/ms170983.aspx

?????

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

??????? ????

???? ??????? SubscriptionStreams "???? ?????" ??????? ?????? ????? ??????. ????? ???? ????? "???? ?????" ????? ????????? ?? ??? ????? ??? ?????. ???????? ??? ???? ?????? ?? ?????? ??????? ????????? ???????? ????? ?????? "???? ?????" ???? ????? ???? ??? ????????.

??????? ????? ??? "???? ???????" ???? ???? ????? ????? ??????? ??????? ?? Studio ????? ???? SQL. a.spid ???
select a.spid, c.text, a.blocked, a.lastwaittype,a.login_time, a.last_batch,
a.hostname, a.program_name  from sys.sysprocesses a, sys.dm_exec_requests b
cross apply sys.dm_exec_sql_text(b.sql_handle) c
where a.spid = b.session_id
and a.program_name like '%<NAME OF YOUR DISTRIBUTION AGENT JOB>%'
????? ??? ????? ??? ??????? ?????? ?? ???? ??????? ???????? (???? 3161) ?? SQL Server 2005 ?????? ????? ?????? SP2. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935356????? ???? ??????? ???????? (???? 3161) SQL Server 2005 ?????? ????? ?????? SP2
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 934188 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.5
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbautohotfix kbhotfixserver kbqfe kbpubtypekc kbexpertiseadvanced kbfix KB934188 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????934188

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

 

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