ᾤࡨ䢴ǹ (ҧ 2153) Ѻ SQL Server 2005

ź ź
Ţ (Article ID): 918222 - ԵѳǢͧ㹺
· | غ

Һ˹ҹ

䢴ǹͧ Microsoft SQL Server 2005 ١ҧѺкآͧ sql server سͧ䢴ǹͧ SQL Server 2005 Service Pack 1 (SP1) õԴ SQL Server 2005 SP1 ¤ hotfix service pack ͧ SQL Server service pack Ѵ仢ͧ SQL Server

sql Server 2005 SP1 ֧͵ԡ SQL Server 2005 ֧ ҧ 9.0.1530ѺǡѺ÷䢴ǹͧ SQL Server 2005 SQL Server 2005 Service Pack 1 ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
913090¡âͧѡѺ SQL Server 2005 Service Pack 1
ᾤࡨ䢴ǹ (ҧ 2153) Ѻ SQL Server 2005 Сͺ䢴ǹͧ SQL Server 2005 ١ SQL Server 2005 SP1 çҧçѺ SQL Server 2005 builds 9.0.1531 ҹҧ 9.0.1540 roughly

˵:ҧ¡ԡ䢴ǹѧ١¡ҧ 2153

˵طӤѭǡѺᾤࡨ䢴ǹ

  • 䢴ǹͧ sql Server 2005 ҵҧ 㹢й ᾤࡨ䢴ǹҹѺҷ
  • سͧԴᾤࡨФ๹ѺкԺѵԡâͧس
  • سͧԴҹ SQL Server Ѵѵ (SMO) SQL Server ᨡ¨Ѵѵ (SQL DMO) ¡кǹҹ͹سԴᾤࡨ䢴ǹ ٢ǡѺ͡ XPs SMO/DMO, SQL Server 2005 ˹ѧ͹Ź

    ˵:˵ sql Server 2005 ˹ѧ͹Źõ駤鹢ͧ鹵͹ҹѴ 0 (OFF) ҧá ҹ١ͧ ¤ õ駤 1 (ON)
  • سͧԴᾤࡨͧ๹觷㹺 ҤسԴᾤࡨͧ๹ӴѺ١ͧ سҨѺͤʴͼԴҴ

    Ѻ ԡŢ仹 ʹٺ㹰ҹͧ Microsoft::
    919224: سҨѺͤʴͼԴҴͤسԴᾤࡨ䢴ǹ (ҧ 2153) Ѻ SQL Server 2005
  • ͵ͧö͹õԴ䢴ǹ Թôѧ仹:
    1. ԡ÷ӧҹԡἧǺ ԡ ź.
    2. ˹ҵҧ ԡ ͤ͡͹
    3. ͵ͧô١¡ԡʴõԴ Microsoft SQL Server 2005 ͡ʴѺاͧͧ
    4. سͧ͹õԴᾤࡨͧǹСͺ觷㹺

ԸաâѺᾤࡨ䢴ǹѺ SQL Server 2005 (ҧ 9.0.2153)

ᾤࡨ๹Ѻ x кԺѵԡ÷ x86

Ҥسѧ¡ SQL Server 2005 x x86 кԺѵԡ سͧԴᾤࡨͧ๹仹ӴѺʴ:
sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x86-ENU.exe

Microsoft SQL Server 2005 ԡ
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x86-ENU.exe

Microsoft SQL Server 2005 ԡ
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x86-ENU.exe

ԡá͹ͧ Microsoft SQL Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x86-ENU.exe

ԡá§ҹͧ Microsoft SQL Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x86-ENU.exe

ͧ Server 2005 sql
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x86-ENU.exe

ᾤࡨ๹Ѻ x кԺѵԡ÷ x64

Ҥسѧ¡ SQL Server 2005 x 64 кԺѵԡ سͧԴᾤࡨͧ๹仹ӴѺʴ:
sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x64-ENU.exe

ԡ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x64-ENU.exe

ԡáͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x64-ENU.exe

ԡá͹ͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x64-ENU.exe

ԡá§ҹͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x64-ENU.exe

ͧ Server 2005 sql
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x64-ENU.exe

ᾤࡨͧ๹ѺкԺѵԡ÷ Itanium

Ҥسѧ¡ SQL Server 2005 кԺѵ Itanium سͧԴᾤࡨͧ๹仹ӴѺʴ:
sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-ia64-ENU.exe

ԡ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-ia64-ENU.exe

ԡáͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-ia64-ENU.exe

ԡá͹ͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-ia64-ENU.exe

ԡá§ҹͧ sql Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-ia64-ENU.exe

ͧ Server 2005 sql
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-ia64-ENU.exe
ҡͧ÷ҺǡѺôǹŴʹѺʹعͧëͿ ôԡŢ仹ʹٺ Microsoft Knowledge Base::
119591ԸѺʹѺʹعͧëͿҡԡ͹Ź
Microsoft ᡹ Microsoft ͿǨͺش ѹաûС ѧǨж١ѴѡҤʹ 觪»ͧѹ¹ŧѺ͹حҵ

sql Server 2005 ɳ-SP1 䢴ǹ SQL Server 2005 ҧ 9.0.2153

˵:ҹͧ Microsoft Ƕ֧͵ԡҹ͡ վҹ
غҧµҧ
Ţͺͧͧ sql͸Ժ:
410ʹ¢ͧԵʹѺʹعʴ͵ԺǵѡԵ١ѡ
433ҤسԹ繤 DDL ¹ŧӴѺԵԨҡҹͧ͡ӴѺ鹨ҡ١ȡ ԴҶ֧ҨԴ
447ûżŻԷҾ÷ӧҹŵ somewhat ҡҷҴ
459ʶҹóҡ੾ ¾ deadlock ҨԴҧͺ ͧ SQL Server 2005 㹡óչ deadlock 㹡õǨͺк辺 deadlock ҧʪѹ
461˹Ҩ respected ͵ҧ١ʴ Microsoft Office Excel §ҹСͺµҧ ͹䢢ͧ NoRows =ԧ NoRowsMessage = null еҧСͺ㹵ҧǡдͷ¡д
464˹ͧѪշ clustered ҨǴѪҹ
491On a SQL Server 2005 installation that uses Turkish collation, you cannot view job steps that are of SSIS type from SQL Server Management Studio. If a job has SSIS job steps only, you receive an "Index was outside the bounds of the array. (SqlManagerUI)" error message when you click the鹵͹
499A Multidimensional Expressions (MDX) query that involves non-trivial custom rollups when it runs complex sum-like aggregate expressions runs much slower on SQL Server 2005 than on SQL Server 2000.
531When you run a query or a stored procedure in SQL Server 2005, certain conditions can cause the SQL Server optimizer not to be able to produce an execution plan.
541ء ADOMD.NET ѹ ¼ԡá IXMLA ١ӡѴѧʪѹͧ٧ش 32
554ͤسͺis_placeholdermemberҪԡسѵѺҪԡԵ.Properties("IS_PLACEHOLDERMEMBER")ѧѹ MDX ҷ١觡Ѻ FALSE ѡɳС÷ӧҹԴзѺҪԡ繵ִ˹觢ͧԵ
584§ҹСͺٻҾ¹͡ Ѿҡ㹺ԡ§ҹ §ҹѧѹ§ӴѺẺͺ ٻ١᷹ ¤ x ᴧ
606кǹmdschema_propertiesõ駤ǪԴͧŷ١ͧѺҧسѵԷ˹¼觡Ѻ
608Ҥس§ҹǹ¢ͧ ФسԴҹHideDuplicatesسѵ´㹡èѴԹ ԡ§ҹͧ SQL Server 2005 raises ͼԴҴͤس§ҹ͡ ԴͼԴҴѧͤسԡҧ͹ҧ㹵͡Ẻ§ҹ
614ԡ§ҹͧ SQL Server 2005 Ҩʴ System.NullReferenceException¡㹹ReportSnapshot.EnsureAllStreamsAreClosed鹵͹ ѡɳС÷ӧҹҧẺ mini-dump
615ԡ SQL Server 2005 Analysis Services ӧҹͤس Japanese_Unicode_CI_AS 繡ººѺԹᵹͧ SQL Server 2005 Analysis Services
617ͤس¡§ҹ١§! UserID ФسѵԢͧôԹ١駤ҡ Snapshots سѺͤʴͤʴͼԴҴ仹:
3wp ! ź! 1 ! 1/27/2006-13:10:27:: բͼԴҴ: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
627ҭ蹢ͧ SQL Server 2005 ҧèѴ˹ fulltext Studio Ѵ SQL ФسѺͤʴͤʴͼԴҴ仹:
աк @ category_name (ѡ '??????' localized) (Microsoft SQL Server ͼԴҴ: 14262)
636˹¤ҨԴ㹡ѹ仢ͧ (CLR) Ҥس觪Դŷ˹ CLR 繾 кǹҹ ѧsp_executesql鹵͹
652աԴТͺ Y-axis Y-ҵشͧشŷդҨӹǹ "" ҵش Y-axis ж١Ѻا繤ҷӡ ҧ äǺἹԻѴ 4.0 ֧ 4 ҧҨӹǹ "" ҧá Y-axis ªͷҧ鹨١ͧ
664س¡ SQL Server 2005 Analysis Services builds 9.00.1520 ҹ 9.00.1539 SQL Server 2005 SP1 㹡óչ MDX ͺաѴӹǹᵡҧѹҨ׹Ѿ ѡɳС÷ӧҹԴ鹶աѴ queried Сͺ¾Ԫѹ੾
708ԡáúԡ㹡 SQL (SSIS) ÷ӧҹͤسԴ SQL Server 2005 SP1
752MSMQTask.dll ҧԧ١ź䢴ǹ͸Ժ㹺ҹͧ Microsoft 910070
40000100Һѷ᷹ҹѹ֡dbcc dbreindexѪ alter .. .rebuild觷ӧҹǡѹ ˹ҷҹѹ֡ҨҴҧá价 distributor
40000102ͤس駤Ҥ͹ԡúѹ֡èѴ ͧͧ ҡͺѹ֡èѴ ҹ鹷ͧسشж١Ǩͺ Ҿ ͧ
40000108 SQL Server 2005 ҹѺҹҨ͡ҡͧաèѴӴѪǹͧҳ١ѺͧѺѭҳҧҴԴ
40000110äӹdz YTD ١ȡ颹Ҵ١ѡҨ١ͧ
50000104кǹSqlCommandBuilder.DeriveParameters(SqlCommand)Ըա觡ѺҢ¡ͤس¡кǹҹѺѺû͹ҷ繪Դ XML
50000112Ҫԡͧҷкҹ SQL Server 2005 Analysis Services ö źͧ Ҫԡͧҷͧ SQL Server 2005 Analysis Services ҹöӧҹ
50000115Ẻͧ§ҹҨ觢 Analysis Services Ẻͺ MDX ١ҧ鹨ҡҧ§ҹѺ蹢ͧ§ҹ ѹ㹡ͺ MDX ͹ѹǹ transposed
50000116ôԹùشҨҶҵҧ·ҧѺմѪշдѪշ clustered ѡɳС÷ӧҹԴ ҴѪդ繷ҧ͡շشѺôԹù жẺͺ SELECT ѺẺҡ
50000120 SQL Server 2005 Analysis Services Ҫԡӹdz˹ cube MDX ʤԻ䢡͹ʪѹ Ẻͺ˹㹡äӹdz ¡ҹʶҹóҧҧѺVisualTotalsѧѹ ѡɳС÷ӧҹա¹ŧҡѡɳС÷ӧҹͧԡ SQL Server 2000 SQL Server 2000 Analysis Services 觤ӹdzöáʪѹ͡äӹdz˹ẺͺҧäӹdzдѺ cube ͧ ¹ŧѡɳС÷ӧҹҨҪԡͺࢵӹdzẺͺʪѹ觡ѺѾسͧ㹺ԡ SQL Server 2005 Cumulative hotfix package for SQL Server 2005 (build 9.0.2153) introduces new syntax that allows for control over the scope in which a calculated member is evaluated.
50000151When you run a SELECT query to return any duplicate rows in a table, incorrect results are returned if the query plan contains a hash aggregation and if one or more of the columns in the table contain a combination of empty strings and undefined characters.
50000154You may receive a variablelock list error message when you run multiple instances of a package.
Ѻ ԡŢ仹 ʹٺ㹰ҹͧ Microsoft::
915918FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005

ҧԧ

ѺǡѺԸաâѺ SQL Server 2005 Service Pack 1 ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
913089ԸաâѺ service pack شѺ SQL Server 2005
For more information about the new features and improvements in SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
916940A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1
ѺǡѺҧ駪ѺûѺا Microsoft SQL Server ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
822499ẺἹõ駪ѺᾤࡨѺاͿͧ Microsoft SQL Server

سѵ

Ţ (Article ID): 918222 - Ǥش: 15 Ҥ 2554 - Revision: 4.0
Ѻ
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL 2005 Server Enterprise
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL 2005 Server Workgroup
  • Microsoft SQL Server 2005 Express Edition
Keywords:
atdownload kbsql2005rs kbsql2005engine kbsql2005as kbsql2005ns kbsql2005tool kbsql2005ssis kbsql2005setup kbtshoot kbinfo kbexpertiseinter kbexpertiseadvanced kbqfe kbmt KB918222 KbMtth
¤
Ӥѭ: «ͿŴ¤ͧ Microsoft ᷹繹ѡŷ繺ؤ Microsoft պ¹ѡкŴ¤ سöҶ֧㹰ҹͧ Ңͧسͧ ҧá Ŵ¤Ҩբͺͧ ҨբͼԴҴ㹤Ѿ ٻẺҡó ǡѺóշǵҧҵԾٴԴ;ٴҢͧس Microsoft ǹѺԴͺͤҴ͹ ԴҴͤ·ԴҡҼԴҴ ͡麷Ţͧ١ Microsoft աûѺاͿŴ¤繻Ш
仹繩Ѻѧɢͧ:918222

ʹ

 

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