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

?????? ????????? ?????? ?????????
???? ???????: 830210 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

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

??? ??? ?????? ????? ??? ?????? ??? ????? ????? ???????? ????? ??????? SQL Server ?????? ????????? ??????? ??????? ??? ??? ???????? ??? ?? ????????? ??? ????? ????? ????? ???????? ????? ???? ??? ??? ????? ????? ??? ??????? ??? ????????. ??? ??? ?????? ??? ??? ????? ?? ????? ??? ???????? ????? ?????? ?????? ????? ???????? sp_addmergearticle ? ?????? ????????? ??????? ??? ??????? ???????? ??? ?? ?????????. ??? ???? ?? ???? ??????? ????? ?????? ?????? ????? ???????? sp_addarticle ?????? ????? ??? ?????? ??? ???? ?? ??? ????? ??????? ?????? ????????? ??????? ??????? ??? ??? ??? ???????? ??? ?? ????????? ??? ????? ????? ????? ???????? ????? ???? ??? ??? ????? ????? ??? ??????? ??? ????????.

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

?????? ??? ???? ?? ????????? ??? ????? ????? ????? ???????? SQL Server ????? ??????? ???? ??????? ?????? ?? "??? SQL Server ???????":

How to modify publications and articles (Enterprise Manager)

??????? ????

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

?????? ????? ??? ???? ?? ??? ????? ??????? ????? ??????? ????? ?????? ?????? sp_addarticle ????? ????????. ??? ???? ??? ??????? ??????? sp_addarticle ????? ???????? ?? ??? ???????? ?????. ?????? ??? ????? ???????? ???? ???? ??? ????? ?????. ?????? ????? ???? ??????? ???????:
  1. ??? ????? ????? ??????? SQL Server.
  2. ?? ????? ??????? ??? ???? ?? ??? ???? SQL Server ???? ????? ??? ???????.
  3. ?? ??????? ?????? ??? ??? ???? ??????? ?? ???? ??? ????? ? ????? ?????????.
  4. ?? ???? ?????? ????? ? ????? ??????? ??? Instance Name ???? ?? ??? ???????. ???? ??? ??????? ???????? ?????.
  5. ?? ????? ???????? ????? "SQL"-< ????? ??? > ???? ?????? ??? ?????? ???????? ????? ?????? ? ???? ?????? ?????? ?????? ????? ????? ??? ??????? ?? ???? ??? ??????.
  6. ?? Script ???? ????? ???????? ?????? ?????? ? ???? ??? ??? ????.
  7. ?? ???? ?????? ???? ??? ???????? ????? ???? NewArticle.sql ?? ?????? ??? ????? ?? ???? ??? ???.
  8. ??? ????? "???? ??????? SQL ?? ?? ?????? ??? ???? SQL Server ???? ????? ??? ???????.
  9. ?????? ????? ??? ?????? ??? ??????? ????? ?????? SQL ???????? ?????? ??? ??? ?? ???? ??????? SQL ?? ?????? ??? ????? ?????? ???????.
    • ???? ???????? ???????? ?????? ????
      USE <Publication Database>
      GO
      
      EXEC sp_addarticle 
      	@publication = N'<Publication Name>', 
      	@article = N'<Article Name>', 
      	@source_owner = N'dbo', 
      	@source_object = N'<Article Object Name>', 
      	@destination_table = N'<Destination Table Name>', 
      	@type = N'logbased', 
      	@creation_script = null, 
      	@description = null, 
      	@pre_creation_cmd = N'drop', 
      	@schema_option = 0x00000000000000F1, 
      	@status = 0, 
      	@vertical_partition = N'false', 
      	@ins_cmd = N'SQL', 
      	@del_cmd = N'SQL', 
      	@upd_cmd = N'SQL', 
      	@filter = null, 
      	@sync_object = null, 
      	@auto_identity_range = N'false'
      GO
      
      ?????? ??? ??? ??? ?????? SQL ???????? ???? ????? ??? ????? ?????? ?????? sp_addarticle ????? ???????? ???? ?? ????????? ?????? ???? ??? ??????? ?? ??? ???????? ????? NewArticle.sql ?? ?????? ?? ?????? 7.

      ???? ?? ????? ???????? ??????? ??? ?? ???? ?? ??? ????? ?????? SQL ????????.

      ?? ??? ??????????? ??? ??????
      ???????????
      @ ?????????? ??????? ??????.
      @ ?????????? ??????? ????.
      @ source_object??? ?????? ??????? ???? ??? ????? ??????? ????.
      @ destination_table??? ?????? ?????? ???? ???? ??????? ?? ??? ???????.
      @ force_invalidate_snapshot1 (??? ??? ???? ??? ?????? ????? ???????.)


      ???????? ??? ???? ??? ??? ??????? ????? ??? ???? ???? ????? SQL Server ?????? ?????? ???? ???? ??? ????? @ auto_identity_range ??????? ??? true.
    • ???? ???????? ???????? ????? ?????????sp_addarticle @ ???????
      USE <Publication Database>
      GO
      
      EXEC sp_addarticle 
      	@publication = N'<Publication Name>', 
      	@article = N'<Article Name>', 
      	@source_owner = N'dbo', 
      	@source_object = N'<Article Object Name>', 
      	@destination_table = N'<Destination Table Name>', 
      	@type = N'logbased', 
      	@creation_script = null, 
      	@description = null, 
      	@pre_creation_cmd = N'drop', 
      	@schema_option = 0x00000000000000F3, 
      	@status = 16, 
      	@vertical_partition = N'false', 
      	@ins_cmd = N'CALL sp_MSins_<Article Name>', 
      	@del_cmd = N'CALL sp_MSdel_<Article Name>', 
      	@upd_cmd = N'MCALL sp_MSupd_<Article Name>', 
      	@filter = null, 
      	@sync_object = null, 
      	@auto_identity_range = N'false'
      GO

      ?????? ??? ??? ??? ?????? SQL ???????? ???? ????? ??? ????? ?????? ?????? sp_addarticle ????? ???????? ???? ?? ????????? ?????? ???? ??? ??????? ?? ??? ???????? ????? NewArticle.sql ?? ?????? ?? ?????? 7.

      ???? ?? ????? ???????? ??????? ??? ?? ???? ?? ??? ????? ?????? SQL ????????.

      ?? ??? ??????????? ??? ??????
      ???????????
      @ ?????????? ??????? ??????.
      @ ?????????? ??????? ????.
      @ source_object??? ?????? ??????? ???? ??? ????? ??????? ????.
      @ destination_table??? ?????? ?????? ???? ???? ??????? ?? ??? ???????.
      @ ins_cmdsp_MSins_ CALL < ????? ??? >
      @ del_cmdsp_MSdel_ CALL < ????? ??? >
      @ upd_cmdsp_MSupd_ MCALL < ????? ??? >
      @ force_invalidate_snapshot1 (??? ??? ???? ??? ?????? ????? ???????.)


      ???????? ??? ???? ??? ??? ??????? ????? ??? ???? ???? ????? SQL Server ?????? ?????? ???? ???? ??? ????? @ auto_identity_range ??????? ??? true.
    ??? ????? ??????? ??? ?????? ??? ??????? ?????? ?? ????? ????? ??????? ???????? ???? ??? ?????? ????? ??? ??????? ?????? ??? "??":

    "???????? ??????": ?? ????? ??? ???????? ??? ??? ???????? ?? ??? ???????.
  10. ????? ???????? ??????? ??? ??????? ??? ???????.
    • ???? ???????? ???????? ?????? ?????

      ??? ?????? ????? ???? ????? ??? ??????? ?????? ????? ?????? SQL ???????? ?? ???? ??????? SQL ?? ?????? ??? ????? ?????? ???????. ??????: sp_addsubscription @ ???????
      USE <Publication Database>
      GO
      
      EXEC sp_addsubscription 
      	@publication = N'<publication Name>', 
      	@article = N'<Article Name>', 
      	@subscriber = N'<Subscriber Name>', 
      	@destination_db = N'<Destination Database>', 
      	@sync_type = N'automatic', 
      	@update_mode = N'read only', 
      	@offloadagent = 0, 
      	@dts_package_location = N'distributor'
      GO
      ?????? ??? ?? ???? ???? ??? ?????? SQL ???????? ???? ????? ??? ???? ????? ???????? sp_addsubscription ????? ??????? ???? ?? ???????? ?????? ???????? ???? ?? ??? ???????? ????? NewArticle.sql ?? ?????? ?? ?????? 7.

      ???? ?? ????? ???????? ??????? ??? ????? ??????? SQL ????????.

      ?? ??? ??????????? ??? ??????
      ???????????
      @ ?????????? ??????? ??????.
      @ ?????????? ??????? ????.
      @ ?????????? ???????.
      @ destination_db??? ????? ???????? ?????? ???? ????? ??? ????????.


      ??? ????? ?????? ?? ??? ?? ???? ????? ???????? ???? ???? ????? ????? ?????? ????????.
    • ???? ???????? ???????? ???????? ?????

      ?????? ?????????? ??? ?????? ????? ?? ?????????? ????? ?? ???? ????????? ???????? ??? ??????? ????? ?????? SQL ???????? ?? ???? ??????? SQL ?? ?????? ??? ????? ?????? ???????. ????? ??? ????: @ ???????
      USE <Publication Database>
      GO
      
      EXEC sp_refreshsubscriptions 
      	@publication = N'<Publication Name>'
      GO
    ?? ????? ????? ??????? ???????? ???? ??? ?????? ????? ??? ??????? ?????? ??? "???":

    "???????? ??????": ??? ? ????? ??? ???????? ????? ???????? ?? ??? ???????.
  11. ?? ?????? "???? ????" ???? ?????? ?? ??????? ?????? ?????.
  12. ?? ?????? "???? ???????" ???? ?????? ?? ?? ?????? ????? ??? ??????? ??????.

?????

?????? ??? ???? ?? ????????? ??? ???? ????? ???????? ????????? ??????? ???? ??? ????????? ?????? ????? ????????, ???? ???????? ??????? ?? "??? SQL Server ???????":
sp_addsubscription

sp_refreshsubscriptions

sp_addarticle


?????? ??? ???? ?? ????????? ??? ????? ??? ??????? ???? ??????? ?????? ?? "??? SQL Server ???????":
Managing Identity Values


?????? ??? ??????? ?????? sp_addmergearticle ????? ???? "? ???? ??? ????? ???????? ??????? ?????? ??" ????? ??????? ?? Microsoft ":
297369FIX: ???? ????? ??? ????? ??? ????? ??????? ????? ??? ????? ???????? "??????? ???????? ??"

269204BUG: ?? ????? ????? ??????? ????? ?? ???? ????? ?????? ????? "???? ????" ???

???????

???? ???????: 830210 - ????? ??? ??????: 06/???? ??????/1428 - ??????: 1.8
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbreplication kbhowtomaster kbcodesnippet kbhowto KB830210 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????830210

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

 

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