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

?????? ????????? ?????? ?????????
???? ???????: 320499 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

?? ??? ???????? ?? ????? ???? ???? ?????? ????? ???????? ???????? ???????? ??????? ????????? ???? ?? ??????? ???????? ???????:
  1. ???? ????? ????? ???? ???? ??? ???????.
  2. ????? ??? ?????? ??????? ????? ??????? ????????? ????????? ???; ??? ?? BCPs ????? ????.
  3. ???? ????? ??????; ????? ??? ????? ????? ????? ??? ?????? ?? ??? ?????.
?? ??? ???????? ????? ??????? ????? ?????????? SQL Server ?????? ??? ?? ????? ???????? ???????? ??? ?? ????? ??????? ???????? ???????? ??? ???????; ??????? ????? ???? ????? ????? ???????? ??????? ?????? ??????? ????? ????????, ??? ????? ???????? ?????? ?? ?????? ??? ??????. ???? ??????? ??????? ??????? ??????????? ???? ??? ???? ??????? ?????? ?? ???? ???????? ???????.

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

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

?? ?????? ???? ?????? ????? ???????? ????????? ?? ????? ?????? ???????? (?? ???????) ?? ??? ?????????. ????? ??????? ???????? ????????? ????? ??????? ????? ???????? ???????? ?????? ???????? bcp ? ????? ????? ????? ???????? ? ?? ???? ???? ????????? ??? ????? ???????? ????????. ?? SQL Server 2000 ????? ???? ???? ????????? ????? ???? ?????. ???? ??? SQL Server 2000 ? SQL Server 7.0 ?????? ???????? ???????? ??? ??????? (FTP). ??? ???? ????? ??????? ????? ????? ????????? ??????? ???? ?? ?????? ???? ??? ????????.

????? ????????? ????? ?????? ?????? ?? ????????? ??? ??????? ????? ??? ????? ????? ???? ??? ????? ???? ??????? ????? ??? ??????? ????? ???????? ????????. ????? ????????? ?????? ???????? ????? ???? ???????? ???? ?? ??? ????? ??? ??????? ?????? ????? ????????; ?? ???? ????? ????? ??? bcp ??????? ??? ??????.

???? ??????? ???? ???? ???????? ?? ????? ???????? ????????. ?????? ??????? ????? ???? ???????? ????? ?? ????? ???????? ????????. ????? ????? ????????? ?????? ???? ???? ???? ??? ???? ????? ???????? ???? ?? ??? ?? ??? ????? ????? ???????? ??? "????????? ??????". ?????? ????? ??????? ??? ?????? ??????? ??????? ????? ????? ?????? ?????? ??? ??????? ???? ?????? ????????. ????? ????? ????????? ??? ???????? ????? ????? ???? ??? ?? ???? ????? ???????? ?? ??? ???????? ??????. ????? ?????????? ??? ???????? ????? ??? ?? ?????? ????? ????????? ??????. ??? ??? ???? ???????? ????? ????? ????????? ??? ???????? ???? ??????? ???????:
  1. ???? ????? ???????? ???????? ??? ??? ??????? ?? "??????? ??????" ??? ????? ??? ????? "?????? ?????????".
  2. ?? ????? ??? ??????? ?? ????? ???????? ????????.
  3. ???? ???????? ?? ??? ????? ????? ????? ???? ??????? ???? ???? ??????? ???????? ?? ???? ??????? ???????? ?? ??????? ??????.
?????? "????????" ? ???? ??????? ???????:
  1. ??? ????? ???????? ???????? ?? ??? "???????? ????" ???? ??????? ??? ??????? ?? ????? ???????? ?? ???? ????? ??????? ??????: sp_dboption 'DBNAME' ?? '?????? ????' ?? '????'. ???? ??? ??? ??? ??????? ??? ??????? ?? ????? ????????. ??? ???? ????; ??? ?????? ?? ?? ???? ?????? ??????? ?? ???????. ??? ????? ???? ??????? ????? ???????? ??????? ??? ????? ???????? ??? ????? ??????? sp_dboption ?????.
  2. ?? ???? ??????? ????? ????? ????????? ?????? ?????? ???? ???????? ????? ???????? ????????. ?? ???? ??????? ????? ??? ???????? ?????? ???? ???????? ??? ????????? ?????? ???????? ????????.
  3. ????? ?????? ???? ??? ???????. ??? ?? ?????? ?????? ???????.
  4. ????? ????? ???????? ???? ?? ?????? "????? ???? ???????". ????? ???? ????? ??? ????? ???. (???? ??? "???? ???????" ?? ??? ??????? ??? ??? ??????? ????? ???????? [?? ????? ????????? ??? ????????] ??? ???????.)
  5. ????? ????? ???????? ?? ??? ???????? ?????? ?? ???? ??????? ??????? ??????? ?????? ???????: sp_dboption 'DBNAME' ?? '?????? ????' ?? '???'. ???? ??? ????? ???????? ??? ????? ????? ???? ????????? ??? ????? ?????? ???????.
  6. ??????? ????? ?????? ??? ???????. ?? ???? ??????? ????? ??? ???????? ??????? ?????? ?????????? ??????? "?" ????? ????????? ??? ????????. ???? ????? ??? ?? ?? ???? ??? ??????? ??? ??? ??????. ??? ???? ?????? ???? ????? ????? ???????? ??? ?????????. ???? ?? ????? ???? ?? ?????? 4.
  7. ????? ??????? ????? ? ????? ? ??? ????????? ????? ????? ????????. ????? ????? ?????? CREATE PROCEDURE ?????? ??? ??? ????????? ??? ????? ??? ????????? ???????: (????????? ????? ???????? ??? ??? ????? ???????? "?" ????? SQL Server)
    1. ?? SQL Server 2000: sp_scriptpublicationcustomprocs

      ????? sp_scriptpublicationcustomprocs ??????. ???? ??? ??????? ?????? ?? ????????? ??????? ???????? ?? ??? ???????. ????? ???????? ????? ???? ?? ?????? ?? ????? ???????? ????????.
    2. ????? ???? ? ????????? ?? ????? ????????: sp_script_synctran_commands

      ?????? ????? ???? ? ????????? ?? ????? ???????? ??????? ??? ?????? 4. ??? ????? "???? ?????" ??? ????? ??????? sp_script_synctran_commands ??? ????? ?????? ??????? ??? "???? ???????" ?????? ???? ??? ?????? MSsubscription_agents. ??? ????? "???? ?????" ????? ???????? ????? ???? ?? ?????? ?????? sp_script_synctran_commands ??? ????? ?????? ???????. ??? ????? ????? ??????? sp_scriptpublicationcustomprocs ????? ???? ?????????? ????? ???? ??? ?????? "?" ???????? ????? ???? ?? ?????? ?? ????? ???????? ????????.

    3. ??? ????? ??????? sp_script_synctran_commands ??? ????? ?????? ???????; ??? ???? ??? ???? ????? ????? "???? ?????" ?????? ???? ??? ???? MSsubscription_agents ??? ?? ???? ????? ??????? ???? ?? ??????? ??? ????? sp_script_synctran_commands. ??? ???? ????? ????? sp_scriptpublicationcustomprocs ???? ?????????? ?? "????? ????" ??? ??????. ????? ???????? ????? ???? ?? ?????? ?? ????? ???????? ????????.
    4. ?? SQL Server 7.0: sp_scriptinsproc, sp_scriptdelproc ? sp_scriptupdproc, sp_scriptmappedupdproc

      ????? ??? ????????? ??????? ?????? ?? ??? ??????? ?????? ??? ???????. ?????? ??? ??????? ?????? ????? ???????? ????????.
  8. ??? ????? ???? ???????. ?? ????? ??? ????? "???? ?????" ???? ?????? ????????. ?????? ????? ?? ?????? - ????? ??? ??? ??????? "???? ???????".
????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
299903FIX: sp_scriptpublicationcustomprocs ?????? ??????? ????? ???????? ???? ?? ???????

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

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

??? ??????? ????? ????????? ?? ????????? ?????? ?????? ?? ????? ??? ?? ?????? ??? ???????? ???? ??????? ???????:
  1. ??? ????? ???????? ?? ?? ?????? "???? ???????". ??? ??? ????? ???????? ???? ??? ?????? "???? ???????".

    ??? ???? ????? ???? ????????? ???? ??? ??????? ??? ?????? ?? ????? ???? ????? ???????? ?????.
  2. ????? ????????? ?????? ???????? ???????? ??? ?? ???????? ??? ???????.
  3. ????? ?????? ???? ?? ??? ??? ??? ??????? ?????? ?????? ?????????.
  4. ????? ???? ???.

    ??? ????? "???? ???" ????? ??????? ?????? ?????? ????? ????? ????? ????????. ??? ????? ???? ????????? ???? ?? ??????? ??? ?? ?? ????? ?????? ??? ???????:
    • ??? ??? ?????? ??? ???? ??? ?????? 1 "?" ?????? 2 ?? ??? ??????? ?????? ?????? ??????? ???? ???????. ?????? ?????? ?????? ????? ?????????. ????? ??? ??? ?????? ??????? ??? ???????.
    • ??? ??? ???? ??? ???? ??? ?????? 1 "?" ?????? 2 ?? ??? ??????? ?????? "???? ???" ??? ??? ?? ??? ????? ??? ??????? ???? ??? ???? ?????? ???????. ??? ????? ????? ????????? ?? ????????? ??? ?? ??? ?????? ?? ??????.
    • ??? ?? ????? ??? ???? ??? ?????? 1 "?" ?????? 2 ?? ??? ??????? ?????? ??? ???? ????????? ??? ???????.

??????? ????

????? ?? ????????? ??? ????? ????? ?????? ??????? ?? ???? ???????? ?? SQL Server 2005 ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms151705.aspx
????? ?? ????????? ??? ????? ????? ?????? ??? ?? ???? ???????? ?? SQL Server 2005 ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms152488.aspx

???????

???? ???????: 320499 - ????? ??? ??????: 02/?? ??????/1428 - ??????: 7.1
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
????? ??????: 
kbmt kbhowtomaster KB320499 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????320499

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

 

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