FIX: "???? ?????" ?? ???? ??? ?????? ??? ????? ????? ?????? ??????? ?????? "-SkipErrors" ????? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 938671 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

????? ????? ?????? ??????? ?????? -SkipErrors ?? ????? ?? Microsoft SQL Server 2005 ? ???? ????? ???? ??? ??????. ???? ??? ?????? ????? ??? ????? ?????? ??? ?????? ?????????.

???????? ??? ???? ??? ???? ??? ???????? ?? ???? "???? ?????" ??????? ???????:
??? ????? ?????? ??????? ?? ??? ????? ???????? 22:49:38.195 007 ???? ?? ??????? ? ??? ?? ????? ????? ??? ??? ??????? ?????? ?? ????? ?????? ????? ???????.

18 ???? 007 22:49:38.273 (1 ???????? ?????) ??? ????? ????????? ??? ???????. ?? ????? ???????? (????????? 007 ???? ?? 22:49:38.367 101) ?? 100 command(s).

?? ????? ???????? (????????? 007 ???? ?? 22:49:38.477 100) ?? 100 command(s). ???? 22:49:38.570 007 ???? ?? 1 ??? (?????) ??? ????? ????????? ??? ???????.

?? ????? ???????? (????????? 007 ???? ?? 22:49:38.664 100) ?? 100 command(s).

????

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 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 ??????? ?? ??? "????? ???".

??????? ????

???? ???????? ????? ????? "???? ?????" ???? "???? ?????" ??? ?????. ??? ??????? ??????? ?SkipErrors ????? ????? ???? ????? ????? ??? ??????? ?? ????? ?? ?????? ????????? ?????????.

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

  1. ????? ???? ????? ??????. To do this, run the following scripts in SQL Query Analyzer.
    use master
    go
    exec sp_adddistributor  @distributor = @@SERVERNAME
    go
    exec sp_adddistributiondb  @database = 'distribution'
    go
    exec sp_adddistpublisher  @publisher = @@SERVERNAME, @distribution_db = 'distribution'
    go
    exec sp_replicationdboption pubdb, publish, false
    go
    exec sp_replicationdboption subdb, publish, false
    go
    if db_id('pubdb') is not null
        drop database pubdb
    go
    create database pubdb
    go
    if db_id('subdb') is not null
        drop database subdb 
    go
    create database subdb
    go
    exec sp_replicationdboption pubdb, publish, true
    go
    use pubdb
    go
    create table t(c1 int primary key, c2 int, c3 sysname null, c4 nchar(200) default 'a')
    go
    create unique index c2_idx on t(c2)
    go
    sp_addpublication @publication = 'p1', @status = 'active'
    go
    sp_addarticle @publication = 'p1', @article = 'a1', @source_table = 't', @schema_option = 0x00000000000300f3
    go
    sp_addsubscription @publication = 'p1', @article = 'all', @subscriber = @@servername, @destination_db = 'subdb'
    go
    
  2. Save the following command as a batch file, and then run the file to insert data.
    c: pushd "c:\program files\microsoft sql server\90\com\" del dist.out
    call snapshot.exe -publisher %COMPUTERNAME% -publisherdb pubdb -distributor %COMPUTERNAME% -distributorsecuritymode 1 -publication p1
    call logread.exe -publisher %COMPUTERNAME% -publisherdb pubdb -distributor %COMPUTERNAME% -distributorsecuritymode 1 
    call distrib.exe -publisher %COMPUTERNAME% -publisherdb pubdb -distributor %COMPUTERNAME% -distributorsecuritymode 1 -publication p1 -subscriber %COMPUTERNAME% -subscriberdb subdb 
    start cmd.exe /s /k "logread.exe -publisher %COMPUTERNAME% -publisherdb pubdb -distributor %COMPUTERNAME% -distributorsecuritymode 1 -continuous"
    start cmd.exe /s /k "distrib.exe -publisher %COMPUTERNAME% -publisherdb pubdb -distributor %COMPUTERNAME% -distributorsecuritymode 1 -publication p1 -subscriber %COMPUTERNAME% -subscriberdb subdb -subscriptionstreams 8 -SkipErrors 2601:2627 -Output dist.out -OutputVerboseLevel 2 -continuous"
    popd
    osql -E -S[SQL_server] -Q"insert subdb..t (c1, c2) values (1000, 1000)"
    osql -E -S[SQL_server] -Q"insert subdb..t (c1, c2) values (2500, 1015)"
    osql -E -S[SQL_server] -Q"begin tran declare @v int select @v = 1 while (@v < 1020) begin insert pubdb..t (c1, c2) values (@v, @v) select @v = @v + 1 end commit tran"
    osql -E -S[SQL_server] -Q"declare @v int select @v = 3100 while (@v < 3500) begin insert pubdb..t (c1, c2) values (@v, @v) select @v = @v + 1 waitfor delay '0:0:0.10' end"
    
    ?????? ?????? ?????? SQL_server ???? ??? ???? SQL Server.
  3. ???? ?? ???????? ??? ?? ??? ????? ???? ??????? ??? ????? ?????? ???????.

???????

???? ???????: 938671 - ????? ??? ??????: 18/???/1428 - ??????: 1.4
????? ???
  • 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 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
????? ??????: 
kbmt kbexpertiseinter kbqfe KB938671 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????938671

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

 

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