SQL ????? 2005 ??????? ??????? ?? ??? ?? ?????

???? ?????? ???? ??????
???? ID: 920700 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???:SQL ????? 2005 ??????? ??????? ?????? ?? ????? ??? ?? ????? SQL Server 2005 ?? ??? ??????? ?? ??? ??? ????-????? ????????? ???????????? ??????????? (CTP) ????????? ?? ?????? ?? ?? ???? ?????? ?? ?????? ??, ???????? ?? ??? communicated Microsoft ?? ??? ?? ?? ?????? ?? ??? ???? confusion ???? ??????? ?? ??? ?????? ??? ?????? ???? Microsoft ?? ??????????? seriously ?? ???? ?? ?? ???????? ?????? ??? ??????? ??? ??? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

Microsoft SQL Server 2005 ??????? ??????? (SQL Server ??????? ???????) rebranding Microsoft SQL Server 2005 ?????? ??????? (SQL Server ?????? 3.0) ?? ???? ???????? ???????? ??? SQL ????? ?????? 3.0 Microsoft Visual Studio 2005 ?? SQL Server 2005 ?? ??? 2005 ??? ???? ???? ??? ??? SQL ????? 3.0 ?????? ?????? ?? ??????? ?? ?? ??????? PC. SQL Server 3.0 ?????? ?? ?? ????? ??? ?? ??????? ???????? ?????????? ?? ???

???????? ???????? ?? SQL Server ?????? 3.0 ?? ????? ????, ?? ?? Visual Studio 2005 ?? SQL Server 2005 ??????? ???? ????? ???????, SQL Server ??????? ???????, ?? ??? ?? ???????? ??? ???? ??? ??? SQL ????? ??????? ???????, ?? ?? ???? ??? ?????? ?? ????????? ???????? SQL Server 2005 ?? ?? Visual Studio 2005 ?? ?????? ?????

SQL ????? ??????? ??????? ????????? ???????????? ??????????? (CTP) ??? 12, 2006 ?? ?????? ???? ??? ??? SQL Server ??????? ??????? ?????? ????????? 1 (RC1) ?????? 7, 2006 ?? ?????? ???? ??? ??? CTP ??????? ?? SQL Server ??????? ??????? ?? RC1 ??????? ???? ?????? ????????? ?? ??? ?? ??? 15 ?????, 2007 ?? ???? ???? ?? ??? ??? ???????? ?? ??? SQL Server ??????? ??????? ?? ??? (RTW) ??????? ?? ???? ???? ??? ??? SQL ????? ??????? ??????? ??? ?? ??????? 3.1 ?? ??? ????? ????? SQL Server ??????? ??????? ?? RTW ??????? ?? ??? ???? ?? ??:
  • Microsoft SQL Server 2005 ??????? ??????? ??????
  • Visual Studio 2005 ?????? ??? 1 (SP1) ?? ??? Microsoft SQL Server 2005 ??????? ??????? ?????
  • Microsoft SQL Server 2005 ??????? ??????? ?????? ?????????? ????????? ??? (SDK)
  • Microsoft SQL Server 2005 ??????? ??????? ????? ?????
  • ?????? Microsoft SQL Server 2005 ??????? ??????? ????????
SQL ????? ??????? ??????? ??? ???????? ?? ??? ????? ?????? ??? ???? ???? ??? ??:
  • ?????
  • ?????????
  • ??????
  • ??????
  • ???????
  • ??????
  • ???????
  • ???????? ????
  • ??????? ????
  • ????
SQL ????? ??????? ??????? ?? ?????? ??? ?????? ??? releases SQL ????? ?? ??? ????? ?????? SQL Server 2005 ?????? ??? 2 (SP2) 2007 ?? ???? ?????? ??? ???? ???? ?????? High-level highlights ???? Microsoft SQL Server ??????? ??????? ???? ???? ?? ??? ????? ???:
  • SQL ????? ??????? ??????? ??? ?? ?????? ?? ?? ?? ???? ?? ??????? ?? ????????
  • SQL ????? ??????? ??????? ??? Microsoft ?????? 2007 ?? ???? ?????? ??? integrated ?? ????? ???
  • SQL ????? ??????? ??????? ?? SQL Server 2005 SP2 ?? ??????? ?? ??? ?? ??? ??? ??????? ???? ??????

???? ???????

SQL ????? ??????? ??????? ?????? (SQLServerCE31-EN.msi)

SQL ????? ??????? ??????? ??? ?????? ????? ??????????? ?? ?????? ???? ?? ??? ????? ???? ?? ???? ?? ?? ???????? ?????????? ?? ?? ??????? PC. SQL Server ??????? ??????? ?? ????????? ?? ?????????? ???? ?? ??? ?? ????? ??? ?? lightweight ??????? ??????? ????? ?? ??? SQL ????? ??????? ??????? ?????? SQL ???????? ?? ?????? ???? ??? ??? ??, SQL Server ??????? ??????? ?????? ????? ?? ?? ????? ?? ???? ?? ?? API SQL ????? ?? ??? ???? ???? ?????, ?? ?? ???? ??? ?? ????? ?? ?????? ???????? ????????? SQL Server ?????? ?? ????? ???? SQL Server ??????? ??????? ?? RTW ??????? ?? ????? ??? SQL ????? ??????? ??????? ????? ?? ???????? ????|DataDirectory|??????????? ???????? ?????? ?? ClickOnce ????????? ???? ?? ???? ?? ??? ???????

SQL ????? ??????? ??????? ?????? ?? ??????? ???? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?familyid=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3
SQL ????? ??????? ??????? ?????? ?????? ????? DLL ??? ????? ???:
  • Sqlceca30.dll
  • Sqlcecompact30.dll
  • Sqlceer30en.dll
  • Sqlceme30.dll
  • Sqlceoledb30.dll
  • Sqlceqp30.dll
  • Sqlcese30.dll
  • System.Data.SqlServerCe.dll
SQL ????? ??????? ??????? ?? ?????? (SQLServerCE31-EN.msi) ?? ??? Microsoft Windows ??????? ?????? ?? ??? ?? ?????? ??? ??????? ?????? ????? SQL Server ??????? ??????? ?? ?????? serviceability ?? ????? ???? ?? ??? ?? ??????? ????? ??? ??????? ??? ?? ?? SQL Server ??????? ??????? ??????? ??, ??????? (System.Data.SqlServerCe.dll) ??? ??????? ??????? ??? (GAC) ??????? ??? ??? ??, OLE DB ??????? (Sqlceoledb30.dll) ??????? ???

OLE DB ??????? ?? ??????? ???? ?? ??? ???? ?????????? ?????? ???? ?????? ??? ?????, ?? ??????? ???? ?? ???? SQL Server ??????? ??????? ?? ?? ?? ???? ??? ?????????? ????????? ???? ??????? ?????? ?? ????????? "%ProgramFiles%\Microsoft SQL Server ??????? Edition\v3.1" ??????? ??? ??????? ???? ??? SQL ????? ??????? ???????, ?? ??????? ???? ?? ??? ??Microsoft SQL Server 2005 ??????? ???????????????? ??? ????? ??? ???????? ?? ????????? ???????.

?????????? ??????? (SQLServerCE31-??????? ???? ?? ???[LN].MSI), ???????? ??????? (SQLServerCE31-EN.msi) ?? ??????? ???? ?????? ???? ??, ?? ???? ??? ?????????? ??????? ??????? ?????
???:[LN]???????? ???? ?? ???????????? ???? ???

SQL ????? ??????? ??????? ????? Visual Studio 2005 SP1 (SSCE31VSTools-ENU.exe) ?? ???

SQL ????? ??????? ??????? ????? Visual Studio 2005 SP1 ?? ??? SQL Server ??????? ??????? ?? ??? ??????? ??? ??????? ?? ????? ?? Microsoft Visual Studio 2005 SP1 ??????? ?????? ????? ????? ?? ?????? ???? ???

??????? ?? ??? SQL Server ??????? ??????? ????? Visual Studio 2005 SP1 ?? ???, ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?FamilyId=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en
?????????? ??????? (SSCE31VSTools-??????? ???? ?? ???[LN]. exe), ???????? ??????? (SSCE31VSTools-ENU.exe) ?? ??????? ???? ?????? ???? ??, ?? ???? ??? ?????????? ??????? ??????? ?????

SQL ????? ??????? ??????? ?????? SDK (SSCE31SDK-ENU.msi)

SQL ????? ??????? ??????? ?????? SDK ????????? ?? ???? ??????? ?????? ?? ??? ??? ????????? ?? ??? SQL Server ??????? ??????? ?? ????? ???? ?? ?? ??? ????? ??????? ??? ??:
  • ?????? ?????? ?? SQL Server ??????? ??????? ?? ??????? ???? ?? ??? .cab ???????
  • ??????? PC ?? ?? ???????? ?????????? ?? SQL Server ??????? ??????? ??????? ???? ?? ??? .MSI ?????
  • ????? ??? ??????? ?? ??? SQL Server ??????? ??????? ????????? ?? ?? ?? ??? ?????? ???
  • SQL ????? ??????? Edition ??? ?????? ??????? ???? ?? ??? .MSI ?????
SQL ????? ??????? ??????? ?????? SDK ?? ??????? ???? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en
SQL ????? ??????? ??????? ?????? SDK ?? ???????? ??????? ??? SQL Server ??????? ??????? ?????? ?? ???? ????????? ??????? ??? SQL ????? ??????? ??????? ?????? ?? ???????? ??????? ?? ?????????? ??????? SQL Server ??????? ??????? ?????? SQL Server ??????? ??????? ?????? SDK ?? ?????????? ??????? ??? ???? SQL ????? ??????? ??????? ?????? SDK ??????? ???? ?? ??? SQL Server ??????? ??????? ?????? ?? ??? ??????? ?????? ????? ??????? ??? ????? ??:
%ProgramFiles%\Microsoft SQL Server ??????? Edition\v3.1\SDK\bin\Desktop
SQL ????? 2005 ??????? ??????? ?????? SDK ?? ?????????? ??????? ?? SQL Server ??????? ??????? ?????? ?? ?????????? ??????? ?? ??????? ???? ?? ??? ????? ????? ?? ???? ????:
  1. ????? ??????? ?????::
    %ProgramFiles%\Microsoft SQL Server ??????? Edition\v3.1\SDK\bin\Desktop
  2. SQL ????? ??????? ??????? ?????? (SQLServerCE31-EN.msi) ?? ????????? ??????? ?? ??????? ?????
  3. SQL ????? ??????? ??????? ?????? (SQLServerCE31-?? ?????????? ??????? ??????? ????[LN].MSI)?

SQL ????? ??????? ??????? ????? ????? (Sqlce30setupen.msi)

SQL ????? ??????? ??????? ????? ????? ?? ??????? ???? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?FamilyId=4E45F676-E69A-4F7F-A016-C1585ACF4310&displaylang=en
???:(Sqlce30setup ?????????? ??????? ?? ??????? ???? ?? ???[LN].MSI), ???? ??? ???? ????????? ??????? ?? ??????? ???? ?? ??? (Sqlce30setupen.msi) ?????

SQL ????? ??????? ??????? ???????? ?????? (SSCE31BOL-EN.msi)

SQL ????? ??????? ??????? ???????? ?????? ??????? SQL Server ??????? ??????? ?? ??? ???????? ??????

??????? ?? ??? SQL Server ??????? ??????? ???????? ??????, ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/downloads/details.aspx?FamilyId=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en
???:?????????? ??????? (SSCE31BOL-??????? ???? ?? ???[LN].MSI), ???? ??? ???? ?? (SSCE31BOL-EN.msi) ????????? ??????? ?? ??????? ???? ?? ??? ?????

Visual Studio 2005 ?? SQL Server 2005 ?? ??? ???-??? ???????

SQL ????? 3.0 ?????? ???????? ?? ??????? ???? ?? ??? Visual Studio 2005 ?? SQL Server 2005 ?? ???????? ??? ???????, SQL Server ??????? ??????? ?? ???????? ?? ???? ??? ?????, ???????????? ?? ?????? ?? SQL Server 2005 ???? ???? SQL Server ??????? ??????? ??????????? ?? ????????? ?? ???? ??? ?? Visual Studio 2005 ??????? ????? ???????, ?? ???????? SQL Server ??????? ??????? ?? SQL Server 2005 ?? Visual Studio 2005 ?? ??? ??????? ?? ?? ???? ???????? ?? ??? ??????? ???????? ???? ?? ???? ??? ???????????? ?? ????? ??? ?? SQL Server 2005 ?? Visual Studio 2005 ?? ??? ???-??? ??????? ??????? ?? ????? ???? ????

????? Studio 2005 ???????

SQL ????? ??????? ??????? ?? ??? ????? Studio 2005
  • Visual Studio 2005 ??? ????? ????? ??????? SQL Server ?????? 3.0 ?? ??????? ?????? ????????? ?????
  • ????? Studio 2005 SQL Server ??????? ??????? ?????? ?? ????? ?? ??????? ???? ??? ?? ??????? ?? ???? ??, ??????? SQL Server ??????? ??????? ??? GAC ??????? ??????? ???? ??? SQL ????? ?????? 3.0 ?????? Visual Studio 2005 ??????? ????? ??? ????? ??? ???????, GAC ?? ?????? SQL Server ?????? 3.0 ??????? ?????, Visual Studio 2005 ????? ????? SQL Server ??????? ??????? ?????? ????????? ???
SQL ????? ??????? ??????? ?? ??? ????? Studio 2005 SP1
  • ?????????? ???????? SQL Server ??????? ??????? ?? ??????? ?????? ?? ????????? ???? ???
  • ????? Studio 2005 SP1 SQL Server ??????? ??????? ?????? ?? ????? ?? ??????? ???? ???

SQL ????? 2005 ???????

SQL ????? 2005 ?? SQL Server ??????? ??????? ?? ??? SQL Server 2005 SP1
  • ??? ?????????? ??????? SQL Server ?????? 3.0 ?? ??????? ?????? ????????? ?????
  • SQL ????? 2005 SQL Server ??????? ??????? ?????? ?? ????? ?? ??????? ???? ???
SQL ????? ??????? ??????? ?? ??? SQL Server 2005 SP2
  • SQL ????? 2005 SP2 ?????????? ??????? SQL Server ??????? ??????? ?? ??????? ?????? ?? ????????? ???? ???
  • SQL ????? 2005 SP2 SQL Server ??????? ??????? ?????? ?? ????? ?? ??????? ???? ???

?? ????????

SQL ????? ??????? ??????? SQL Server ?????? 3.0 ??? ????? ???? ??? ?? ??? ???????? ????? ???? ??? ?? ???????? ??? ????? ????? ???:
  • |DataDirectory|??????????? ???????? ??????
  • ClickOnce ??????

|DataDirectory| ??????????? ???????? ??????

|DataDirectory|(???? ???????? ??? ??????) ??????? ?? ?? ?? ????? ???? ?? ?? ??????????? ???????? ??? ?????, ???? ??? ???? ??? ??? ????? ?? ????? ???? ?? ???? ?? ?? ???? ?? ??? ??? ????? ???, ?? ?? ???? ?? ???????? ?? ????? ???? ??????? ???? ??????? ?? ?? ??? ??????? ??????? serialized ?? ???? ???? ??|DataDirectory|??????????? ???????? ?? ???? ????? ?? ??? ????????? ???? ???? ?? ???? ????????? ?? ?????????? ???? ?? ????

?????? ?? ???, ??? ?? ???? ?? ??? ??? ????? ???, ?? ????????? ?? ???? ?? ????? ??????? ?????????
Data Source= c:\program files\MyApp\Mydb.sdf
??? ?? ?? ?????|DataDirectory|??????????? ????????, ????????? ??????? ???????? ?? ???? ????
Data Source = |DataDirectory|\Mydb.sdf
??? ???? ?? ???DataDirectory???, ???AppDomain.SetData?????? ??? ??? ?? ??? ????DataDirectory??? ?? ???, ??????? ??????? ?? ??????? ?? ??? ??????? ???? ???? ???:
  • ????????? ?? ?????????? ?? ???????? ?? ?? ??????? ??? ?? ??? ???, ?? ??? ??????? ??????? ????????? ??????? ????? ???? ???
  • ????????? ?? ClickOnce ?? ??????? ?? ??? ???, ?? ??? ??????? ??????? ????????? ???? ??????? ????? ?? ????? ???? ???
???:.NET ??????? Framework ?? ?????? ???? ????AppDomain.SetDataMicrosoft Windows ??????-?????? ?????? ?? ?????? ??? ??? ??? ????????? ???AppDomain.SetData?????? ?? Windows-?????? ?????? ?? ???? ??, ?? ???? ?? ?????? ??????

ClickOnce ??????

ClickOnce ?? ??? ??? ????????? ??????? ????? ?? SQL Server ??????? ??????? ?? ?????? ???? ??? ClickOnce simplifies ????????? ?? ???? Windows-?????? ????????? ?? ??? ??? ????? ?? ??? ?? ???? ??????? ????? ???? ???? ?? ??? ??? ?????????? ?? ????????? ?? ???? ??? ?? ???? ????????? ?? ????? ?? ??????? ?????? ???? ?? ?????? ??? ???????? ?????? ?? ????????? ??? ?? ?????? ???? ?? ??? ?????????? ???? ???

????? Studio ?? ???????? ???? ?? ClickOnce ?? ????? ?? ???? ???? ???? ??????????? ?? ?????? ???? ?? ??? ????? ?????? ???? ??? ClickOnce ?????? ?? Microsoft Visual Basic, Microsoft Visual C#, ?? Microsoft Visual J# ?? ????? ?? ???? ?? ??????????? ?? ??? ?????? ??? ???????, ClickOnce ?????? Microsoft Visual C++ ?? ????? ?? ???? ?? ??????????? ?? ??? ?????? ???? ???

?? Visual Studio 2005 SP1 ?? ??? SQL Server ??????? ??????? ????? ??????? ???? ?? Visual Studio 2005 SP1 ?? ??????? ?? ???? ???? ?? ClickOnce ?? ??? ?????? ?????? ??????? ???? ?? ?? ??? ?????????? ??? ?????? ClickOnce ??????? ?? ??????? ???? ???
SQL ????? ??????? ??????? ?? ??? ClickOnce ?? ?????? ???? ?? ??? ???? ????
???:?????? ?? ???????? ?? ?? ??? ??? ????? SQL Server ??????? ??????? ?? ???????? ??????? ?? ????? ????? ??? ?? ???? ???? ???? ??????? ?? SQL Server ??????? ??????? ??????? ???, ??????? ??? ??? ?????? ?? ??? ?? ????? ????? ??? ??????? ??? ?? ???? ??? ?????? ?? ??? ????? ?? ??? "EN." ?? ???? "Zh" ?? ???? ??

SQL ????? ??????? ??????? ?? ??? ClickOnce ??????, ?? ??? Visual Studio 2005 SP1 ?? ??? SQL Server ??????? ??????? ????? ??????? ???? ?? Visual Studio 2005 SP1 ?? ??????? ????? ?? ClickOnce ?? ??? ?????? ?????? ??????? ???? ??? ?????? ClickOnce ?????? ??????? ?????????? ??? ?? ??????? ???? ????? ?????? ClickOnce ??????? ?? ????? ???? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ????????:
Product.XML???? ????? ?? ????????? ???? ??
Package.XML??????????-??????? ??????? ?? ??????????? ???? ????? ?? ????? ?? ??? ????????? ???? ??
SqlCE31eula EN.txtMicrosoft ?????????? ??????? ?????? ??? ????? ????
????? ?????? ClickOnce ??????? ?? ??????? ???????????? ?? ????? ???? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ?????????? ?? ?????? ??????? ??????? ???
Product.XML% ????????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL ????? ??????? Edition\
Package.XML% ????????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL ????? ??????? Edition\en\
SqlCE31eula EN.txt% ????????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL ????? ??????? Edition\en\
SQLServerCE31 EN.msi% ????????? Files%\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SQL ????? ??????? Edition\en\
??? SQL Server ??????? ??????? ?? ??? ??? ?? prerequisite ClickOnce ????? ?? ????? ???? ?? ??? ????? ???? ????????? ?? ???, ClickOnce ??????? ??????? ??? ?????? ?? ?? SQLServerCE31 EN.msi ????? ?? ????? ???? ??? ??????? ????? ?????? ???? ??, ??? ClickOnce ??????? SQLServerCE31 EN.msi ????? Microsoft ??????? ?????? ?? ??????? ????????? ?? ??????

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

SQL ????? ??????? ??????? 3.1, ??? ????? ?????????? ?? ??? ??? ??????? ??? ???????? ??????? ?? ??? ???????? ?????????? ?? ??? ??? ??? ???? ?????, ?? ??????? ??? ???????? ?????? ?? ?????? ???????? ?? ??? ?????????? ??? ?????? ??????? ??? ?? ?????? ???????? ?? ???????? ?????????? ?? ??? ?? ??????? ??? ????? ???? ?????? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ?????????????? ?????? ?? ??? ??????? ?????? ????????? ?????? ?? ??? ?? ??????? ??????????? ?????????? ?? ??? ??????? ?????? ??????????? ?????????? ?? ??? ?? ??????? ???
?????? ???? ????640 KB640 KB640 KB4096 KB
??????? ???? ???2000 ms2000 ms2000 ms5000 ms
??????? ????128 ??128 ??128 ??256 ??
??????? ????? ??? ???????? ?? ????? ?? ???????? SQL Server ??????? ??????? ????? ??? ??? ???? ?? ?????????? ?? ???????? ???????? ?? SQL Server ??????? ??????? ?? ??????????? ?? ????? ????? ??? ???

???:??? ?? ?? SQL ????? ??????? ??????? 3.1 ??? ????? ?????????? ?? ??? ??????? ?????? ????? ??????? ???? ??, ?? ?????? ????? ??? ?? ????????? ?? ????? ?????????? ?? ??? ?????? ???? ?? ?????? ???? ?? ??????? ?????? ????? SQL Server ??????? ??????? 3.1 ??? ??? ??? ?? ??????????? ???? ?? ??? ?????? ???? ?? ???? ???? ?? ?????? SQL Server ??????? ??????? ?? ???? ?????? ??? ??? ???? ??? ?? ??????

SQL ????? ??????? ??????? 3.1 ?? Windows Vista ?? ??? ????? ????????

Windows Vista ?? SQL Server ??????? ??????? ?????? ??????? ??? Windows Vista ?? ??????? ??????????? ?? ??????? thoroughly ??? ???????, ??? ??? ???????? ????? ???????? SQL Server ??????? ??????? 3.1 ??? Windows Vista ??? ????? ???????? ???????? ???????? ?? ????? ?? ?????? ?? ????? ???? ???

???????? ?????? ?? ????, ?? ??? SQL Server 2005 ??????? ??????? ?? ??????? ??????????? ?????? SQL Server 2005 ?????? ??????? ?? ??? ??? ?? ??????????? ?????????? ????? ???? ??? ?? ?????????? ?? ??? somewhat outdated ?? ???? Microsoft ?????? ??????? satisfies ??????? ?? ???? ?????? ????? ?? ??????? ???? ??? ?? ?? ?? ????? ???? ?? ???? ????? ?? ???? ?? ???????? ???? ??? ??? ???? ?? ??? ?????? ?? ???, ????????????? ????? ?????? ???? ?? ?? ????, ????

?????? 1

When you use the Configure Web Synchronization Wizard to configure Microsoft Internet Information Services (IIS) 7.0 on Windows Vista, you receive the following error message:
IIS not installed
Then, the Configure Web Synchronization Wizard fails.

???:???????? ??? ????????????? ??????? SQL Server ??????? ??????? ?? SQL ????? ?? ??? ?????????????? ?? ????? ???? ?? ??? IIS ??? ??????? ?????????? ??? ???? ???
?????? 1 ?? ??? ??????
?? ?????? ?? ???????? ?????? ?? ???, ????? ????? ?? ???? ????::
  1. ???????? ??? ????????????? ??????? ?? ????? ???? ?? ???? IIS 6.0 ??????? ?????? ?? ??? ????? ?? ??????? ?????

    ???:?? ?? ????? ??? ??????? ?? ???? ???????????? ?? ??????????? ???????? ?????
  2. ????????????? ?? ?????? ???? ??? ?? ?? ?? ????? ????????? ????? ?????, ?? ???? ??? ????? ????????? ?? ???????? ??? ????????????? ??????? ??????

?????? 2

?? ?? ??????? ??????????? ?? ??????? SQL Server ??????? ??????? ????? ????? (Sqlce30setupen.msi) ????? ???? ?? ??? ?????????? ???? (LUA) ??? Windows Vista ??, ???? ????? ?????? ????? ??????? ???? ??:
SQL ????? ????????? ??? ???? ????
?? ?????? ?? ???? ??, ??? ?? SQL Server ????????? ??? ????? ???? ?? ?? Sqlce30setupen.msi ????? ?? ????? ???, ?? ???? ?? ????? ?? ???? ??, ?? ????? ??????????? ?? ????? ???? ?? ???? ???????, after ?? ???? ????????????? ???, ?? ??? ?? ?? ?????? ????? ???
?????? 2 ?? ??? ??????
????????????? ?? ?????? ???? ??? ?? ?? ?? ????? ????????? ????? ?????, ?? ??? Sqlce30setupen.msi ????? ??????

?????? 3

?? ?? Windows Vista ?? ??: ???? ??? ?? ??????? SQL Server ??????? ??????? ????? ????? (Sqlce30setupen.msi) ????? ?????, ??????? ?????

?? ?????? ???? ?? ?? ?? ????? ??????????? ?? ????? ???? ?? ??? ???? ??????? ?????????? ?????? ????????? ????? ?? ?????? ?? ???? ?? ??????? ????? ????????? ?? ?? ????? ??????????? ?? ????? ???? ?? ??? ????? ???? ??? ???? ????, ????? ????????? ????? ???????? ?????????? ?????? ?? ????? ??????????? ?? ????
?????? 3 ?? ??? ??????
????? ??????????? ?? ????? ???? ?? ???? ?? SQL Server ??????? ??????? ????? ????? ????? ?? ??? ???????? ?????????? ?????? ????????? ?????

?????? 4

?? ???????? ?? ????? ????.. ?? Visual Studio 2005 ??? ??? ???????? ??? ?? ?? ???????? ?? ???????? ?????? ?? Windows Vista ??? ???????? ??? ?? ???????? ???, Visual Studio 2005 ?? SQL Server ??????? ??????? 3.1 integration ?? ????

SQL ????? ??????? ??????? 3.1 ??? SQL Server ??????? ??????? ????? Visual Studio 2005 SP1 ?????? ?? ??? ??? ?? ????? Visual Studio 2005 ?? SQL Server ??????? ??????? 3.1 ?? ?????? ???? ?? ??? ????? ?? ??????? ???? ??? ?? ????? ?? ??? Visual Studio 2005 ?? ????? ???? ?? ?? ????????? ???????????? ????? ??? ?? ???????? ?????? ?? Windows Vista ??? ???????? ??, ?? ??? integration ??? ???
4 ?????? ?? ??? ??????
?? ?????? ?? ???????? ?????? ?? ???, ????? ????? ?? ???? ????::
  1. Visual Studio 2005 ?? ??? ??????? ?????? ???????????????? ??? ?? ??????? ???? ?????
  2. ??? ?? ???? ?? ?? ??????? SQL Server ??????? ??????? ????? Visual Studio 2005 SP1 ?? ???, Visual Studio 2005 SP1 ?? ??? SQL Server ??????? ??????? ????? ?? ??????? ?????
  3. Visual Studio 2005 ??????? ???? ?? ??????? ?????? ???????????????? ??? ??????? ?????
  4. SQL ????? ??????? ??????? ????? Visual Studio 2005 SP1 ?? ??? ???: ??????? ?????

?????? 5

?? ???????? ?? ????? ????.. ???? ??? Windows Server 2008 ??? ??? ???????? ??? ?? ?? ???????? ?? SQL Server 2005 ?????? ??? 2 ??????? ??? ???????????? ?? ?????? ????????? ????? ??? SQL Server ??????? Studio, ?? SQL Server ??????? ??????? ?? ?? ??????? ????? ???? ?? ???????? ???, ?? ????? ?? ??????? %WINDIR%\SYSTEM32 ??????? ??? ???? ?? ???
?????? 5 ?? ??? ??????
SQL ????? ??????? ??????? ?? ?? ??????? ??? SQL Server ??????? Studio ????? ??? ????? ??? ?? ??? ?? ?? ????????? ?????

SQL ????? ??????? ??????? 3.1 ?? ??? ???? ????? ????????

?????? 1

?? ???????? ?? ????? ????.. ?? ???? ???????? SQL Server ??????? ??????? 3.1 ????????? ClickOnce ?? ????? ?? ???????? ????? ???, ???? ?????? ?? ????????? ?? ???? ???? ???????? ?? ???? ?? ???????? ???, SQL Server ??????? ??????? ?????? ?? ?????????? ??????? ??????? ???? ???
?????? 1 ?? ??? ??????
?? ?????? ?? ?? ???? ?? ??? ClickOnce ?? ??? ???? ????? .XML ????? ?????? ???? ?? ????????? ???? ?? SQL ????? ??????? ??????? ?????? ?? ?????????? ??????? ??????? ?? ?? ?? ????????? ?? ?????? ???? ?? ????

???? ????????? ?? ??? ???? ?? ??? ?? ????? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ?????? ??????? ??? ???? (MSDN) ?? ????:
(VS.80) http://msdn2.Microsoft.com/en-us/library/ms165429 .aspx

?????? 2

?? ???????? ?? ????? ????.. ?? SQL Server ??????? ??????? Runtime ?? ????????? ??????? ??????? ????? ???? ???, ?? ??????? SQL Server ??????? ??????? ?????? ?? ?? ?????????? ??????? ??? ???????? ??? ?? ???????? ???, ?? ????? ?? ????? ????????? ?? ????? Machine.config ????? ?? SQL Server ??????? ??????? ?????? ?? ??????? ???? ???? ???:
SQL ????? ??????? ??????? ???? ???????
???:????? ??????? ??? Machine.config ????? ??:
Microsoft.NET\Framework\v2.0.50727\CONFIG%WinDir
?? ?????? ??????? agnostic ??????????? ??? ???????? ???? ?? ???? ???
?????? 2 ?? ??? ??????
?? ?????? ?? ???? ??? ????? ???? ?? ???, ????? ????????? ??? ?? ???? ?? ?? ????? ????::
  • ???? ????????? ?? ??? ??????? ?? ?? Config.xml ????? ??????
  • ??? ?? SQL Server ??????? ??????? ?????? ?? ?????????? ??????? ?? ??????? ???? ???? ????? ???, ???????? ??????? ?? ??????? ???? SQL Server ??????? ??????? Runtime ?? ?????
  • Machine.config ????? ??? DbProviderFactories ??? ?? ??? ????? ??????? ???????? ??? ?? ???????
    <add name="SQL Server Compact Edition Data Provider" invariant="System.Data.SqlServerCe" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

?????? 3

?? Visual Studio 2005 SP1 ??? ??? ?? ?? ???????? ?? ????? ???? ????????? ?? ??? ?? ??? SQL Server ??????? ??????? ????? ??????? ???? ???? ?? ?????

???:?? Visual Studio 2005 SP1 ??? ??? ????? ???? ????????? ?? ??? ?? ?? ???????? ?? ??????? ?? ???? ???

?????? 4

??? SQL Server ??????? ??????? 3.1, ?? ????? ???? ?? ????sp_repladdcolumn???????? ????????? ?? SQL ??? ??? ????? ???????? ???? ?? ???:
  • ???? ??????? ???? ?? ??? ??? ??? ????? ???????
  • ??? ????? ?? ??? ????? ????? ???????? ??????? ????? ????? ???? ?????? ?????? ?? ???? ????? ?? ?????? ??? ????
?????? ?? ???, ?? SQL Server ??????? ??????? 3.1 ??? ????? SQL ??? ??? ???? ?? ???? ????
Northwind..sp_repladdcolumn  @source_object='Customers' , @column='ColNew' , @typetext='int constraint FK_Foo_Customer foreign key  references Products ( ProductID )' , @publication_to_add='PubName')
4 ?????? ?? ??? ??????
???????? ?? ???-??? ???? ?? ??? ?? SQL ??? ??????

?????? ?? ???, ???????? ?? ?? ?? ????? ??? ?? ???? ?? ??? ????? SQL ??? ??????
EXEC Northwind..sp_repladdcolumn  @source_object='Customers' , @column='ColNew' , @typetext='int' , @publication_to_add='PubName';
Alter table Customers add constraint FK_Foo_Customer foreign key (ColNew) references Products ( ProductID )
?? ??? ?? SQL ??? ?? ?????, ???????? ?????, ?? ???? ??? ??????? reinitialize.

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

SQL ????? ??????? ??????? 3.1 SQL Server ??????? ??????? ?? ????? ????????? ??? ?? ???? ?? ??????? ???? ??? ????? ???? ???? SQL Server ??????? ??????? 3.1 ?? ?? ???? ???? ??? ?? ????? ???? ??:
  • SQL ????? ??????? ??????? ?? ????? ????????? ??? ?? ???????? ???????? ??? ?????, ?? ??????? ???? ?????? Visual Studio 2005 ?? SQL Server 2005 SQL Server ??????? ??????? ?? ??????? ???? ?? ?????

    SQL ????? ??????? ??????? 3.1 ??? ?? ?????? ?? ?? ?? ?? ??? ??? ?? SQL Server ??????? ??????? 3.1 ?? ????? ?? SQL Server ??????? ??????? ?? SQL Server 2005 ?? Visual Studio 2005 ?? independently ??? ???? ????
  • ?? ?? ??? ???? ??? ?? ??? ????????? ?????????? ????? ???????, SQL Server ??????? ??????? ?? ????? ????????? ??? ?????? ????? ????? ?? ??? ???? ?????? ????????? ??? aliases ?? ????????? ???? ????? ???? ????, SQL Server ??????? ??????? ?? ?????? ??????? ????????? ????? ???:
    ????? #<ordinalnumber></ordinalnumber>
    ?????? ?? ???, ???? ??? ???????? ????????
    Select c1 as Col1, NULL as Col2 from Table1
    When you run this statement in earlier versions of SQL Server Compact Edition, you see the following column names in the output:
    column#0, column#1
  • ?? ???????? ?? ????? ????.. You specify the ON DELETE CASCADE constraint on a table in earlier versions of SQL Server Compact Edition. The table has only one row. Then, you delete the row in the table. When you delete the row, an index scan occurs. In this scenario, SQL Server Compact Edition frees the data page that contains the row. Additionally, if the reference count of the buffer or of the frame that holds the data page is zero, SQL Server Compact Edition marks the buffer or the frame as free.
  • When you run earlier versions of SQL Server Compact Edition, you may receive the following error message:
    ????? ?? ?? ???????? ?????? ?? ????? ?? ?????? ???? ???
    ?? ?????? ?? ???? ?? ??? ????? ????????? ???? ???? ???::
    • SQL Server Compact Edition tries to write data to the right node of a binary tree (btree).
    • The binary tree is full.
    ???:When SQL Server Compact Edition writes data to a node of a binary tree, SQL Server Compact Edition splits the node if the binary tree is full. SQL Server Compact Edition uses one of the following methods to split the node:
    • Normal split
    • Asc split
    • Desc split
  • In earlier versions of SQL Server Compact Edition, when you use a scrollable cursor to retrieve data from a binary large object (BLOB) column, a SSCE_M_COLUMNORDINALNOTFOUND error may occur.

    ?? ?????? ???? ?? ??????? scrollable ????? ????? ??? ???????? ??????? ???? differently ?? ???? ???????? ????? ?? ?????? ??? ???????? ??????? ????? ??? ?? scrollable ????? ?? ????? ????, ??????? ??????? ??? ???????? ????? ??????? ???? ?????? ?? ??????? ??? ?? ???? ??? ???????, scrollable ????? ?? ???? ???????? ????? ????? ??????? ???? ?????? ??????? ??? ???????? ????? ?? ???? ?? ??????? ???? ?? ????

???

???? ID: 920700 - ????? ???????: 07 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Compact Edition
??????: 
kbinfo kbexpertiseadvanced kbmt KB920700 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:920700

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

 

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