????? ???????? ??????? ?????????? ???? ?? ??????? ?? ???? ?????? service Pack 1 ?????? ? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 916940
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ?????? ?? ??????? ??????? ?????????? ???? ?? ??????? ?? Microsoft SQL Server 2005 Service Pack 1 (SP1).

??????? ????

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

  • ?? ????? ????????? ???? ???? ???? ????? ???????????.
  • ???? ??? ????? ????? HTTP ??? HTTP.
  • ????????? ????? ?????????? ????? ???? ??????????? ????? ???????? ?????? ????????.

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

  • ??? ??????? ?????? ????? ????? ?? ???? ???? ??? ????? ?????? ?????? "??? ????? ????????" ???????? ??????? ?????? TCP/IP.

SQL Server 2005 ????? Services (SSIS)

  • ?? ????? ?????? ??????? "?????" ?????????/??????? ?? ?????????? ?????? ???????.
  • ???? ???? ?????????????????????????????? ?????? ???? ???????? ??????? ?????? ??????? ??? ?????? "???? ????????" ???????.
  • ?? ????? ??????? ??????? ???????? ?? "????? ???????". ???? DataReader ?? ???? SSIS System.Object ??? ???????? ?? ???? ????? ??????? ???? ????? ??? ??? ???????? ??? ??? ??? ?????? ???????????? DT_NTEXT. ?????? ??? ???????? ??? ??? ???? ?????? ???????? ?????? ??? ????? ????? ????? "????? ????????".
  • ?? ????? ?????? ???????? ????? ??? ????? ?????.
  • ?? ????? ?????? ????????? ??????. ??? ???? ??????? ???? ????? ????? ?????? ???? ???????? ?? ???? ??? ????? ?????? ?????? ??? ???? ???????? ??????. ?? ???? ??????? ??? ???? ?????? ???? ????? ??? ???? ???????? ??????.
  • ????? ???? ??????? ????? ???? ?????? ???? API ?????? ????????. ??? ?????? ??? ????? ??????? ?????? ??? ???????? ???????? ???????? ???????? ?????? ??? ????????? ?????? ?????? ??????? ??????.
  • ???? ?????? ??? ???????? ??? ??????? ??????? ?????? ???? SSIS ??? ??? ????? ????. ??? ???? ??????? ???? ????????? ????? ????? ??? ??? ??????? ?????? ??? ??????? ???. ??? ??? ????????? ?? ???????? ????????? ??? ??? ????????? ?? ?????? ???????? ??????? ????? ??? ???????? ?? Microsoft Windows.
  • ?? ???? ????? ???? ??????? ???? "??? ????" ??? ????? ????? ????????????????. ???? ??? ??????? ????? ?????? ???? ???? ?? ???? ?? ?? ?????? ???????? ??????? ??? ?? ?????? ????.
  • ?? ???? ????? ????? ???? DataReader ???? ?????? ????? ????? CommandTimeout. ????? ??????? ??? ??????? ?????? ???? ?????? ?????? ??????? ??????? ????? ?????.
  • ?????? ?? ????? ??????? ??????? ???????? ?????? ???? ??????? ???? ?????? ?? ????? ???????.
  • ????? ???? ????? ??????? ??????? ??? ???? ????????.

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

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

  • ?????? "????? ??????? ????? ????? ?????" ???? ????? "??????? ??????? ??????" ???? (UTC). ???? ????? ???? ???????? ?????? ????????.
  • ?????? ??????? ????? ???? ?? ?? ??? ???? ???? ????. ????? ?? ??????? ?? ?????????? ??????? ??? ????? ????????. ?? ????? ??? ???????.

    ?????? ?? ??? ?????????? ???? ??? ?? ??????? ???? ?????? ?? ???? ???? ??????? ???? ??? ????? ?? ???? ????? SQL Server 2005. ??? ??????? ???? ?????? ??? ?????. ????? ??????? ??? ????? ??? ?????? ??????? ?? SQL Server 2005 ???????? ?? SQL Server 2000.
  • ?????? ????? ????? ??? ???? ???? ??????? ???? ???? ???????? ??? ??????? ???????. ????? ?? ???? ????? ????? ????? ?? ???? ??? ???? 32 ???? ???? (KB) ??????. ?? ??? ???????? ???? ?????? ???? ?????? ??? ???? ???????. ?? ????? ??? ???????.

???? ???? SQL

  • ??? ????? ????? ????? ????? ??????? ?????? ?? ????? ??? ???? ????? ????? ??? (???? ???????).
  • ?? ???? ???? ?????/???? ????? ????? ???? ???? SQL Server ??? ??????? ??? ???? NetworkService ?? ???? ????? ?? ???? ???.
  • ???? ????? ????? ?????? ????????? ??? ??????? 64 ?? ?? SQL Server 2005 ????? ??? ????? ??????? 64-??.
  • ?????? ?? ??? ???????? XML ???? ?????? ????? (XMLA) ???? ?? 32 ???? ????. ?? ????? ??? ???????. ???? ????? ?????? ???? ????.

SQL Server ????? ???????? (SMO)

  • ?? ????? ???????? ?? ????? ??????? ?????? ???? SMO.
  • ?????? SMO ?? ??? ?????? SQL ???????? ??? ????? ?? ??? ????? ?????????. ???????? ??? ???? SMO ?? ?? ???? ???? ??? ????? ?????? ?? ??? ????? ?????????. ?? ????? ??? ???????.

??? ???????

  • ???? ???? ??? ??????? ????? ???? ???? ????? SQL Server ?? SQL Server 2005 ????? ????? (SSIS) ?????. ?? ???????? ???? ????? ?? ?? ??? ????????.
  • ????? ???? ??????? ???? ??????? ?? ??? ????? ???? ????? ????? ????????? ?? ??????? ???????.

SQL Server ????? Studio (SSMS)

  • ????? ???? ????? ?????? ????? ????? ???????? ?????? ???????? ?? ????? ???????? ?? ??? SQL Server 2000 ???????.

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

  • ????? ???? ??????? ????? ???????? ????? ???????? ????? ????? ??? ???? ????? ????????.
  • ??? ????? ???? ???? "??? ????? ????????" ??? SQL Server ????? Studio. ???? ????? ???? ????? ???? ?? ?????? ?????? ??? ???? ????? ??????? ??? ??? ??????? ?? ???? ??? ??? ????? ????? ???????? ????? ???????? ??????.
  • ???? SQL Server ????? ???????? ???? ??????? ???? ?????? ???? ??????? ??????? ?????????? ??? ???? ON DELETE CASCADE ????? "????? ??????? ???" ?????? ????? ??? ????? precomputed.
  • ?? ????? ?????? ????????? ?? ????? ???????? ????? ???????? ????? SQL.

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

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

  • ????? ???? ????? ??? ?????? ??? ?????? ?????? ?? ???????? ?????? ??? ???????? ?? "???? ???????".
  • ???? ???? ?????? ???????? ???? ???? ??????? ???????? ???? ????? ????????? ?????? ??? ?????????? ???????????? ?? ?????? ????? ???????? SAP NetWeaver ???????.

???? ?????

  • ?? ?? ????? ?????? ?? ??????? ?? ????? "????? ???????" ?? "???? ???????". ??? ???? ??????? "????? ????????" ???? ???? ???? ???? ?? ????? ?????? "????? ???????". ???????? ??? ???? ?? ????? ???? ????? ??????? ????????.
  • ????? ???????? ??????? ?? ???? ????? ??????? ???????? "????? ????? ???????" ?? "???? ????? ???????".
  • ?? ??? ???? ??????? ??????? ??????? ???? ????? ??????? ?? "???? ???????".

???? ????? ?????? ???? SQL

  • ?? ????? ??? ????? ???????? ?? SQL Server 2005 SP1. ??? ???? ??? ????? ???????? ??????? ??? ???????. ?? ????? ????? ?????? ??????? ??? ????? ???????? (t 1400). ????? ??? ??????? ?? ????? ?? ???? ?????? SP1.
  • ??? ????? ???? ???? "??? ????? ????????" ??? SQL Server ????? Studio.
  • ???? ????????? ?????? ???? ?? ???? ????? ????? ?? ???????? ??? ????? ??????? ????.
  • ??? ????? ??? XSD ???? ?????? ??????? ?????? ??????? ??? ????.
  • ????? ????? ???? ??????? ?? ??? ????????. ???? ?? ???? ??? ?????? ????? OpenXML ???? ???? ??????.
  • ?? ????? ??? ????? ???? ???? ????????? "???? ????? ??????". ??? ????????? ???? ????? ??????? ??????? ??? ?????? ???? ?????? SQL Server ?????? ?????? ??????? ??????? ?????? ??? ??? ??????? ?? SQL Server 2000 ??? SQL Server 2005.
  • ??? ????? ????? ???? ???? ?? ?????? ??? ??????? ???????? ??????? ??????? ??? ??????.
  • ??? ????? "???? ????? ????????" ????? (DMVs) ????? ?? ??????? ???? ???? ??????? "????? ?????????".
  • ?? ??? ????? ???? ?????? ????? ???????? (DBCC) ?? ????? Watson. ??? ??? ???????? DBCC ?????? ?? ??? ????? ??????? ????? ??????? Watson ??? ??????? ?? ????? ??? Microsoft.

    ?????? ??? ??????? ??? ??? ????? ???????? ? Microsoft ??????? ?????? ??? ???????? ???? ???? Microsoft ???????? ?? ????? ????????? ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://oca.microsoft.com/en/dcp20.asp
  • ???????? ??? ???? ?? ????? ??????? ?????? ?? ???:
    • ?????? ??? ??????? ??????? XQuery ????? ??? ?????? XML ???????
    • ?????? ??? ????? XML ???????? ??? ????? ?????? XML (XML DML)
    • ?????? ?? dm_exec_query_plan DMV
    • ?????? ?? ???????? ???????? ?????? ???????
    • ???? ??????
    • ???????? ????????? ???????? ????????
    • ????? ??????? ??? ????? SQL ????? ??? ??? ????? (SQLCLR) ?????? ?????? ?????? ??????? ?????????
    • ??? ????? ???? ????? ?????? ???? SQL ????????? ??????? ??????? ?? ??? ???????? ????????? ??????? ??? ???? ?? ??? ???????? (UDT)
    • ???? TPC-H

SQL Server 2005 Express Edition

  • ?? SQL Server 2005 Express Edition "????? ??????" ????? ?????? ???? ????? ??? ?? ??? ???? ???? ?????? ????? ?? SQL Server 2005 Express Edition? ???? ??? ??? ?? ???? ????? ?????? SQL Server 2005 ????? Studio Express. ???????? ??? ???? ????? ??? ?????? ??? ???? ?????? ?????? ?????? SQL Server.
    • ????? ?? ?? ????: ????? ??????? ??? ?????? ?????? ????????? ???? ?????? ????? ???????? ????? ??? ?????? ??????? ?? ????? SQL Serer. ????? ????? ????????? ???? ?????? ??????? ????????? ?? ????? ?????? ????? ?? ?????.
    • ????? ????????: ????? ??? ?????? Studio ????? ???? ??????? ????? ???????. ????? ??????? ??? ?????? ????? ????? ?????? ???????? ?? ????? ???????? ????????? ????????.
    • SQL Server 2005 ????? Studio Express: ??? ?????? ?? ???? ??? ???? ????? ????????? ?????? ?????? SQL Server Express Edition.
  • ????? SQL Server 2005 Express ?? ???? ?????? ?????? ????? Studio ????? ???? ???????. ??????? ????? ???? ????? ???? ?? ????? ?????? ???????? ???????? ??? ??????.

SQL Server 2005 ????? Studio Express

  • ????? Studio Express ???? ???? ?????????.
  • ?????? ????? Studio Express ?? ???? ??? ????? "??? SQL Server". ?? ????? ??? ???????.
  • ????? ???????? ??????? ???? ???? ?????? ???? ?? SQL Server 2005 ????? Studio Express.

?????

????? ?? ????????? ??? ???? ?????? service Pack 1 ?????? ? SQL Server 2005? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ? Microsoft":
913089????? ?????? ??? ???? ???? ???? ? SQL Server 2005
913090 ????? ??????? ???? ?? ??????? ?? ???? ?????? service Pack 1 ?????? ? SQL Server 2005
????? ?? ????????? ??? ??????? ??????? ?? SQL Server 2005? ???? ??? SQL Server 2005 (????? 2006). ?????? ??? ??? ??????? ?? ?????? ???? Microsoft ?????? ??? ?????: http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

???????

???? ???????: 916940 - ????? ??? ??????: 08/?? ?????/1433 - ??????: 1.0
????? ??????: 
kbinfo kbsql2005setup kbexpertiseinter kbexpertiseadvanced kbtshoot kbmt KB916940 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????916940

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

 

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