????? ???????? ??????? ?????????? ???? ?? ??????? ?? ???? ?????? 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
    (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
(http://support.microsoft.com/kb/913089/ )
????? ?????? ??? ???? ???? ???? ? SQL Server 2005
913090
(http://support.microsoft.com/kb/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
(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
(http://support.microsoft.com/kb/916940/en-us/ )
???? ??? ?????? | ????? ???????

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

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