FIX: ??? ?? ???? ????? ???? CDC ??? ??? ?????? ???? ?????? cdc.change_tables CDC ?? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 966306 - ??? ???????? ???? ????? ????? ??? ???????.
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ?? Microsoft SQL Server 2008 ????? ???? ???????? (CDC) ????? ?????? ?????? ??????.
  • ????? ???? ?????? CDC cdc.change_tables.
  • ????? ??????? sp_cdc_disable_db ????? ?????? CDC.
?? ??? ?????????? ?? ???? ????? ????? ???????:
msg 208 ? 16 ??????? 1 ???? sp_cdc_disable_db_internal ????? 82 ?? ??? ?????? ??? ???? 'cdc.change_tables'.

msg 266 16 ??????? 2 ???? sp_cdc_disable_db_internal ????? ??? ????????? ?? 82 ??? ????? ???? ??? ??? ?????? BEGIN ????? ??????. ??? ??????? = 0, ????? ?????? = 1.

msg 266 ????? 16 ???? 2 sp_cdc_disable_db ????? ??? ????????? ?? 0 ??? ????? ???? ??? ??? ?????? ?????? BEGIN ? ????????. ??? ??????? = 0, ????? ?????? = 1.
??? ????? ????? ????? CDC ?????? ?????? ?????? ??????? ??????? sys.sp_cdc_enable_db ????? ?? ????? ??????? ???????:
??? ????? ????? ???????? '<database>' ?????? "???? ????? ????????". ???? ?? ????? ???? ????? ???????? ??????? ?????? ???????. ????? ??? ????? ?????? ????? "?????? ???????? ?????" ????????? ???? is_cdc_enabled ?? ????? ??? ???????? sys.databases.

????

??????? ??????? ???????? ???? ????? SQL Server 2008

?? ????? ??????? ????? ???? ??????? ????? ?? 4 ??????? ???????? ?????? ??? ???? ????? SQL Server 2008. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
963036???? ??????? ???????? 4 SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

??????? ????? ?????? ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 1 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
969099???? ??????? ???????? 1 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1

?????

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

??????? ????

???? ???? ??? ??????? ???? ????? ????? ?????? CDC ??????.

????? ??? ????? ?????? CDC ?????? ?? ???? ?????? ???????? ?? ?????? CDC. ?????? ????? ?? ?????? ????????? ??????:
select * from sys.objects where schema_id=schema_id('cdc')
??? ???? ????????? ?? ???? ??? ?? ????? ????? CDC ????? ?????? ?????? ????? ????? ????? CDC ?????? ???????? ?????? ?? ??? ??? ???????. ???? ?????? ??? ???????? ?? ????? ?????? ????? ???? ???? ??? ????? ?????? CDC. ??? ???? ?? ?????? ??????? sp_cdc_disable_db ????? ??? ????? ????? ?? ??????.

???? ?? ????????? ??? ???? ??????? ???????? 4 ?? SQL Server 2008

?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
963036???? ??????? ???????? 4 SQL Server 2008

???? ?? ????????? ??? ???? ??????? ???????? 1 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1

?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
969099???? ??????? ???????? 1 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ????? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 966306 - ????? ??? ??????: 20/???? ??????/1430 - ??????: 2.1
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbmt kbsurveynew kbexpertiseadvanced kbqfe kbfix KB966306 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????966306

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

 

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