????? ????? ???? ??????? ?????? ?? SQL Server 2000 ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 324401 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ????? ???? ??????? ?? ???? ??????? ???? ????? ??????? Microsoft SQL Server 2000 ?? Microsoft SQL Server 2005. ?????? ???? ??????? ??? ????? ?????????? ?? ????????? ? ???? ?? ?????? ?? ??? ????? ????????. ????? ????? ????? ???????? ?? ???? ????? ?????? ??? SQL ???????? ???? ??? ??????? ?????? ????? ??????? SQL Server ?? SQL Server ????? Studio. ??? ???? ??? ??? ?? ???? ????? SQL ???????? ???????? ????? ?????? ????? ????????, ????? ?????? ????? ????? ???????? ???????? ???? ????? ????????? ?????? ?????? SQL ????????. ????? ??? ??????? ??? ??????? ??? ???? ????? ????????? ???? ???? ????????? ?? ??? ???????.

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

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

????? ?????? ????? ???? ??????? ???????? ???? ????? ????????? ?????? ?????? SQL ????????. ?????? ???? ??????? ??????? ???? ??????? ???????:
  1. ????? ???? ?????????? ??? ????? ????? ????????.
  2. ????? ???? ????????? ???? ??? ????? ????? ????????.
  3. ????? ???? ?? ?????? ?? ??? ????? ????????.
?????? ??? ??? ????????? ?????? ?????? ??? ??? ?? ????? ???????? ???? ??? ?? ??? ???????. ?????? ???????? ????????? ??????? ? ???????? ??? ??? ????? ???????? ???? ???? ???????.

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

?????? ?? ?????????? ?? ???? SQL Server ????? ??????? ????????? ??????? ??????? ???????? ????????:
  • sp_dropsubscription: ????? ??????? ????? ?????? ?????? sp_dropsubscription ????? ?????????? ?? ??????? ????? ?? ????? ?? ?????? ?? ???????? ?? Publisher. ??? ????? ????? ???? ?? ???? Publisher ??? ????? ?????? ???????.
  • sp_droppullsubscription: ????? ??????? ????? ?????? ?????? sp_droppullsubscription ??????? ?????? ?? ????? ???????? ??????? ?? ???????. ??? ???? ????? ??????? ?????? ??? ??????? ??? ????? ?????? ???????? ?????.
  • sp_dropmergesubscription: ????? ??????? ????? ?????? ?????? sp_dropmergesubscription ????? ?????? ?? ????? ??? ? ????? ??? ????? ?? ????? ???. ??? ????? ????? ???? ?? ???? Publisher ??? ????? ?????? ???????.
  • sp_dropmergepullsubscription: ????? ??????? ????? ?????? ?????? sp_dropmergepullsubscription ????? ?????? ??? ???. ??? ???? ????? ??????? ?????? ??? ??????? ??? ????? ?????? ???????? ?????.

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

?????? ?????? ??? ????? ???????? ?????? ???? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_dropsubscription @publication = N'<Publication name>', @article = N'all', @subscriber = N'all', @destination_db = N'all'
?????? ?????? ???? ??? ??? ???? ???????? ?????? ???? ???? ??????? ???????:
  1. ????? ???????? ????? ?????? SQLb ??? ???????:
    USE <Subscription database name>
    GO
    EXEC sp_droppullsubscription @publisher = N'<Publisher server name>', @publisher_db = N'<Publication database name>', @publication = N'<Publication name>'
  2. ????? ???????? ????? ?????? ?? Publisher:
    USE <Publication database name>
    GO
    EXEC sp_dropsubscription @publication=N'<Publication name>', @subscriber = N'<Subscriber server name>', @article = N'all', @destination_db = N'all'

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

?????? ?????? ??? ????? ???????? ????? ??????? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_dropsubscription @publication = N'<Publication name>', @article = N'all', @subscriber = N'all', @destination_db = N'all'
?????? ?????? ??? ????? ???????? ????? ??????? ???? ??????? ???????:
  1. ????? ???????? ????? ?????? ??? ???????:
    USE <Subscription database name>
    GO
    EXEC sp_droppullsubscription @publisher = N'<Publisher server name>', @publisher_db = N'<Publisher database name>', @publication = N'<Publication name>'
  2. ????? ???????? ????? ?????? ?? Publisher:
    USE <Publication database name>
    GO
    EXEC sp_dropsubscription @publication =N'<Publication name>', @subscriber = N'<Subscriber server name>', @article = N'all', @destination_db = N'<Destination database name>'

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

?????? ?????? ??? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_dropmergesubscription @publication = N'<Publication name>', @subscriber = N'<Publisher server name>', @subscriber_db = N'<Subscription database name>', @subscription_type = N'push'
?????? ?????? ??? ???? ??????? ???????:
  1. ????? ???????? ????? ?????? ??? ???????:
    USE <Subscription database name>
    GO
    EXEC sp_dropmergepullsubscription @publication = N'<Publication name>', @publisher = N'<Publisher server name>', @publisher_db = N'<Publisher database name>'
  2. ????? ???????? ????? ?????? ?? Publisher:
    USE <Publication database name>
    GO
    EXEC sp_dropmergesubscription @subscription_type = N'pull', @publication = N'<Publication name>', @subscriber = N'<Subscriber server name>', @subscriber_db = N'<Subscription database name>'

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

??? ????? ???? ?????????? ???????? ?? ????? ????? ????? ???????. ??? ????? ????????? ?? ????? ???????? ??????? ??? ???? ????? ???? ????? ???????? ????? ???????? ?????? ?????? ??????? ??? false. ?????? ????? ????? ??????? ????????? ??????? ?????? ???????:
  • sp_droppublication: ????? ??????? ????? ?????? ?????? sp_droppublication ????? ????? ????????? ???????? ?? ???????. ??? ????? ??????? ?????? ?? Publisher ??? ????? ?????? ???????.
  • sp_dropmergepublication: ????? ??????? ????? ?????? ?????? sp_dropmergepublication ????? ????? ??? ? "???? ????" ????? ?? ????? ???. ??? ????? ????? ???????? ???????? ?? ???????. ??? ????? ??????? ?????? ?? Publisher ??? ????? ?????? ???????.
  • sp_replicationdboption: ????? ??????? ????? ?????? ?????? sp_replicationdboption ????? ???? ????? ?????? ????? ?????? ?????? ???????? ???????. ??? ????? ????? ???? ?? ???? Publisher.
?????? ????? ???? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'

USE master
GO
exec sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'
?????? ????? ??????? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'

USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'
?????? ????? ??? ????? ???????? ????? ?????? ?? Publisher:
USE <Publication database name>
GO
EXEC sp_dropmergepublication @publication = N'<Publication name>'

USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'merge publish', @value = N'false'

????? ?????

??? ????? ???? ?????????? ???????? ????? ????? ???? ??? ?????. ??? ???? ??? ????? ????? ??? ????? ??????? ??????? ?? Publisher. ?????? ????? ?????? ????????? ??????? ???????:
  • sp_dropsubscriber: ????? ??????? ????? ?????? ?????? sp_dropsubscriber ????? ??????? ??????? ?? ???? ?????. ??????? ?????? ??? ????? ????? ??????? ?? ???????. ??? ????? ????? ???? ?? Publisher ??? ????? ???????? ???????.
  • sp_dropdistributor: ????? ??????? ????? ?????? ?????? sp_dropdistributor ?????? ?????. ??? ????? ????? ???? ?????.
?????? ??????? ??????? ?? Publisher ????? ???????? ????? ?????? ?? Publisher:
USE master
GO
EXEC sp_dropsubscriber @subscriber = N'<Subscriber server name>', @reserved = N'drop_subscriptions'
?????? ????? ????? ???????? ????? ?????? ?????:
USE master
GO
EXEC sp_dropdistributor @no_checks = 1

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

????? ????? ??????? ????????? ??????? ??????? ??? ????? ????? ????????:
  • sp_removedbreplication: ????? ??????? ????? ?????? ?????? sp_removedbreplication ??? ????? ???? ?????? ????? ???????? ?? ????? ?????? ??? ????? ???????? ?? ??????. ??? ????? ??????? ?????? ?? Publisher ??? ????? ?????? ??????? ?? ??? ??????? ??? ????? ?????? ????????. ???? ?????? ???? ?????? ??? ??????? ??????: sp_removedbreplication
    sp_removedbreplication '<Database name>'
  • sp_droparticle: ????? ??????? ????? ?????? ?????? sp_droparticle ????? ???? ?? ????? ???? ?? ?? ????? ?????????. ?? ????? ????? ???? ???????? ??? ???? ?? ???? ?? ?????????? ?? ??????? ???????? ?? ???? ??????. ??? ????? ??????? ?????? ?? Publisher ??? ????? ?????? ???????. ???? ?????? ???? ?????? ??? ??????? ??????:
    sp_droparticle @publication = N'<Publication name>', @article = N'<Article name>', @force_invalidate_snapshot = 1

?????

????? ?? ?????????? ???? ???????? ??????? ?? "??? SQL Server ???????":
  • ????? ????? ????? ? ????? (Transact-SQL)
  • ????? ??? Publications and ?????? (Transact-SQL)
  • ????? ??? ?????? ??? (Transact-SQL)
  • ????? ??? ?????? ??? (Transact-SQL)
  • ????? ??? ?????? ????? (Transact-SQL)
  • ????? ??? ????????? ????????? (????? ???????)
  • ????? ??? ?????? ??? (????? ???????)
  • ????? ??? ????? ?? ???????? ????? (????? ???????)

???????

???? ???????: 324401 - ????? ??? ??????: 21/????/1426 - ??????: 3.3
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbhowtomaster kbreplication kbstoredproc KB324401 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????324401

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

 

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