SQL Server 2000 , , . SQL Server 2000.
Microsoft SQL Server 2000 , . SQL Server:
1. MSSQLServer;
2. SQLServerAgent;
3. Microsoft Search (MSSearch);
4. Microsoft Distributed Transaction Coordinator (MSDTC).
SQL Server 2000 , , . Windows 95/98 , SQL Server 2000 . , SQL Server 2000 . Microsoft Windows 95/98, Windows NT. SQL Server 2000.
1. MSSQLServer
MSSQLServer SQL Server 2000 . MSSQLServer , , , , , .
MSSQLServer SQL Server 2000 . MSSQLServer SQL Server . , .
MSSQLServer, SQL Server 2000. MSSQLServer , , SQLServerAgent, .
2. SQLServerAgent
SQLServerAgent SQL Server 2000. . SQLServerAgent , . , . .
|
|
SQLServerAgent MSSQLServer. SQLServerAgent, SQLServerAgent MSSQLServer.
SQLServerAgent :
1. Jobs (). , . (schedule) . , (on demand), .. .
2. Operators (). operators . , . . . , , . , , , , .. , . , , .. , . , . SQL Server 2000 , , , . SQLServerAgent. , . SQLServerAgent . , net send, . net send , , - . net send .
3. Alerts (). Alerts , SQL Server 2000. SQLServerAgent . SQL Server 2000 , SQL Server 2000. , . , , .
|
|
, , Msdb. SQLServerAgent . , SQLServerAgent .
SQLServerAgent , , . SQLServerAgent . , SQL Server 2000.
3. Microsoft Search
Microsoft Search (MSSeareh), Full-Text Search, SQL Server 2000. (full-text search). , , .
, .
SQL Server 2000 (full-text catalog) (full-text index). . MSSeareh. MSSQLServer MSSeareh (full-text provider).
MSSearh (repopulation) . , (rebuild) . , . . , .
4. MSDTC
SQL Server 2000 . , . , Microsoft SQL Server 2000, , OLE DB. , Oracle, FoxPro, MS Access . ., , , , MS Excel .
SQL Server 2000 (distributed transaction). (Distributed Transaction Coordinator). SQL Server 2000 MSDTC. , . , . MSDTC . , . MSDTC , .
|
|
SQL Server 2000
SQL Server 2000 , SQL Server 2000 . . Windows, . . SQL Server 2000. : 1) Master; 2) Model; 3) Tempdb; 4) Msdb.
, . , . SQL Server 2000. SQL Select, Insert, Update Delete. , SQL Server 2000 . select.
SQL Server 2000 , . Microsoft , . , . Microsoft SQL Server. SQL Server 2000 , , . Microsoft , .
.
1. Master
SQL Server 2000. , Windows. . Master , , , , .
Master (. 1).
Master Data SQL Server 2000. :
- Master.mdf , . 8 ;
- Master.ldf , . 1 .
2. Model
C Model . SQL Server 2000 : Model . , , Model. , . Model. , Enterprise Manager Transact-SQL, .
|
|
Model, . , Model . Model , , .
3. Tempdb
, , . SQL Server 2000 . # ##. . . , . . #, @.
, , . . ##, @@.
Tempdb, Temporary DataBase, SQL Server 2000 , . , , , Tempdb. Tempdb , .
Tempdb , , . , , , . SQL Server 2000 Tempdb . , Tempdb . .
4. Msdb
Msdb , SQL Server 2000, . , . Msdb , SQLServerAgent.
SQL Server 2000
, SQL Server 2000 , , . SQL Server 2000. . , , SQL Server 2000 ( engine). SQL Server 2000 , SQL Server 2000 . , SQL Server 2000 SQL Server 7.0. SQL Server 6. , .
1. Enterprise Manager. :
- ;
- ;
- ;
- ;
- SQL Server 2000;
- ;
- , ;
|
|
- ;
- , DTS
Enterprise Manager .
SQL Server 2000 :
- Transact-SQL;
- Enterprise Manager;
- (wizards).
. Transact-SQL, , Query Analyzer ( ). Transact-SQL .
Enterprise Manager , . Enterprise Manager , , . , Transact-SQL. Enterprise Manager , Transact-SQL, . Transact-SQL , . Enterprise Manager .
2. SQL Server Service Manager. SQL Server Service Manager , SQL Server 2000. , .
Service Manager SQL Server 2000 . Service Manager (taskbar). , , SQL Server 2000, .
3. SQL Server Profiler. SQL Server Profiler , SQL Server 2000. , , Transact-SQL, , SQL Server 2000 . . SQL Server Profiler . , SQL Server 2000, . , , SQL Server 2000 .
4. Query Analyzer. . Query Analyzer Enterprise Manager. SQL-, Query Analyzer Execute Query, . SQL Query Analyzer. Query Analyzer , 1.
, SQL Query Analyzer . (Object Browser), , , . , . <F8> Tools Object Browser, Show/hide. .
Query Analyzer . Debug. Debug Procedure, , . (break points), .
, Query Analyzer . (estimated) (execution plan) , Query, Display Estimated Execution Plan Display Execution Plan. , . . , . , , . - .
2 . . , , .
5. Upgrade Wizard. Upgrade Wizard SQL Server 6.5 SQL Server 2000. SQL Server 2000 , , , , , , , . , . .
6. Import and Export Data. / , DTS, . .
. , DTS, , . . MS Excel, . , .
7. Client Network Utility Server Network Utility. SQL Server 2000. , , (Network Library). (DLL, dynamic link library) . , .
SQL Server 2000, . , Server Network Utility, SQL Server 2000. , .. , . . Client Network Utility, SQL Server. Enterprise Manager, Query Analyzer . , , , .
8. . , , SQL Server 2000 , . , , SQL Server 2000, .
. Binn SQL Server 2000, , PATH.
9. . , . . . . , . , Enterprise Manager, . , Transact-SQL. , .
SQL Server 2000.