SQL Server 2000, , . Microsoft (Total Cost of Owner) . SQL Server 2000 , . , , SQL Server 2000. (typical) , , . .
, (custom) . , , .
. .
, SQL Server 2000. SQL Server 2000 SQL Server 2000 . . , , , .
, , SQL Server 2000, (edition), , .
, SQL Server 2000, .
:
- ;
- ;
- SQL Server 2000.
SQL Server 2000 . . SQL Server 2000 , .
|
|
, SQL Server 2000, 2.
, SQL Server 2000 . .
, SQL Server 2000 , . .
SQL Server 2000 :
- Windows 98;
- Windows NT Workstation 4.0;
- Windows NT Server 4.0;
- Windows 2000 .
, SQL Server 2000 c Windows 95. , SQL Server 2000.
SQL Server 2000 Windows NT Server Windows NT Workstation Service Pack 5.0 . SQL Server 2000 Windows 2000 .
SQL Server , . SQL Server 2000 , .
SQL Server 2000 Windows 2000: NetBEUI, IPX/SPX TCP/IP. , AppleTalk ADSP, Banyan VINES .
, SQL Server 2000.
, , , . , .
Windows NT Windows 2000 . , .
:
1. Local System ( ) , . . , , . . , . . SQL Server 2000 , , SQL Server 2000.
|
|
2. Local User ( ). , . SQL Server 2000 , , SQL Server 2000, .
3. User for Domain ( ). (domain controller) Windows NT Windows 2000 , . .
, SQL Server 2000, , , MSSQLServer, :
- \Program Files\Microsoft SQL Server\Mssql;
- mdf, ndf Idf;
- :
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer,
HKEY_LOCAL_MACHINE\System\Cun-entControlset\Services\ MSSQLServer.
SQL Server 2000 . , . , , .
, SQL Server 2000. , ( , ) . , , : ; ; , ; SQL Server 2000 .
, , . , , SQL Server 2000. , .
SQL Server 2000 , Services Control Panel ( ) Enterprise Manager.
SQL Server 2000 , . (collation) , , .
SQL Server 2000 ( Unicode) (Unicode) . . , :
- Unicode ( char, varchar text);
- Unicode ( nchar, nvarchar ntext);
- , Unicode.
, SQL Server 2000 . , , . . , 65, 66, 67 . . , , G, , F, , , , , , F, G. , . . , . , . SQL Server 2000 (sort order):
|
|
- Binary , . ;
- Case sensitive , . SQL Server 2000 . , ;
- Accent sensitive .
. (check box). - , . .
(code page) , char, varchar text. 256 . , 1 , 256 . , (character set).
( 0127) . , , , , , , . ( 128255) .
SQL Server 2000 16 , 1251, .
Unicode
256. . , . , . , . . , .
SQL Server 2000 Unicode. 256 , . Unicode 1 , , 2 . 65 536 (216). . SQL Server 2000 Unicode: nchar, nvarchar ntext.
|
|
SQL Server 2000
, Unicode. SQL Server 2000 . SQL Server 7.0 SQL Server 2000 . , , , .
SQL Server2000 SQL Server 7.0 , . , .
SQL Server 2000 , .
Windows , Windows. . SQL Server 2000. , Regional Options Control Panel.
SQL SQL Server. . , SQL SQL_Latinl_General_CPl_CI_AS (Dictionary Order, Case-insensitive), 1252 (ISO Code Page 1252) Unicode (General Unicode Collation).
SQL SQL Server. Windows. , SQL Server 2000 .
SQL Server 2000 . , SQL Server 2000 , . , SQL Server 2000 . .
SQL Server 2000 , . , . Windows, SQL Server 2000, . , .
, SQL Server 2000.
SQL Server 2000. , , (network library). (dll, dynamic link library,) . , .
SQL Server 2000 . , SQL Server 2000.
1. AppleTalk ADSP. , Apple Macintosh SQL Server 2000, AppleTalk, TCP/IP Sockets.
|
|
2. Multiprotocol. , RPC . Windows NT: TCP/IP Sockets, Named Pipes, NWLink IPX/SPX .. Windows NT , Windows NT . SQL Server 2000 Windows 98.
3. Named Pipes. , SQL Server 2000 Windows NT Windows 2000 . Windows.
4. NWLink IPX/SPX. , SQL Server 2000 Novell NetWare.
5. Shared Memory. , , ( ) , . - . SQL Server 2000, .
6. TCP/IP ( TCP/IP). , TCP/IP . -. TCP/IP . SQL Server 2000 1433.
7. Banyan VINES. , Banyan VINES IP.