search for books and compare prices
Tables of Contents for McSe Microsoft SQL Server 2000 Administration
Chapter/Section Title
Page #
Page Count
Welcome to Microsoft SQL Server 2000 Administration
ix
Before You Begin
x
Using the MCSE Readiness Review
xii
Exam Objectives Summary
xviii
Getting More Help
xx
Installing and Configuring SQL Server 2000
1
44
Tested Skills and Suggested Practices
1
3
Further Reading
4
3
Install SQL Server 2000
7
8
Questions
9
2
Answers
11
4
Upgrade to SQL Server 2000
15
6
Questions
17
2
Answers
19
2
Create a linked server
21
6
Questions
22
2
Answers
24
3
Configure SQL Mail and SQLAgentMail
27
6
Questions
28
2
Answers
30
3
Configure network libraries
33
6
Questions
35
2
Answers
37
2
Troubleshoot failed installations
39
6
Questions
40
1
Answers
41
4
Creating SQL Server 2000 Databases
45
32
Tested Skills and Suggested Practices
46
1
Further Reading
47
2
Configure database options for performance
49
6
Questions
50
2
Answers
52
3
Attach and detach databases
55
6
Questions
56
2
Answers
58
3
Create and alter databases
61
8
Questions
62
2
Answers
64
5
Create and manage objects
69
8
Questions
71
3
Answers
74
3
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
77
46
Tested Skills and Suggested Practices
78
2
Further Reading
80
3
Optimize database performance
83
8
Questions
85
3
Answers
88
3
Optimize data storage
91
6
Questions
92
2
Answers
94
3
Modify the database schema
97
6
Questions
99
1
Answers
100
3
Perform disaster recovery operations
103
8
Questions
104
4
Answers
108
3
Perform integrity checks
111
6
Questions
113
2
Answers
115
2
Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL
117
6
Questions
118
2
Answers
120
3
Extracting and Transforming Data with SQL Server 2000
123
46
Tested Skills and Suggested Practices
124
2
Further Reading
126
3
Set up Internet Information Services (IIS) virtual directories to support XML
129
6
Questions
130
2
Answers
132
3
Import and export data
135
6
Questions
137
2
Answers
139
2
Develop and manage Data Transformation Services (DTS) packages
141
8
Questions
142
4
Answers
146
3
Manage linked servers
149
6
Questions
151
1
Answers
152
3
Convert data types
155
6
Questions
156
1
Answers
157
4
Configure, maintain, and troubleshoot replication services
161
8
Questions
163
2
Answers
165
4
Managing and Monitoring SQL Server 2000 Security
169
46
Tested Skills and Suggested Practices
169
2
Further Reading
171
4
Configure mixed security modes or Windows Authentication
175
6
Questions
177
1
Answers
178
3
Create and manage logons
181
8
Questions
182
3
Answers
185
4
Create and manage database users
189
6
Questions
190
2
Answers
192
3
Create and manage security roles
195
6
Questions
196
2
Answers
198
3
Enforce and manage security by using stored procedures, triggers, views, and user-defined functions
201
4
Questions
202
1
Answers
203
2
Set permissions in a database
205
6
Questions
206
1
Answers
207
4
Manage security auditing
211
4
Questions
212
1
Answers
213
2
Managing, Monitoring, and Troubleshooting SQL Server 2000
215
28
Tested Skills and Suggested Practices
216
1
Further Reading
217
2
Create, manage, and troubleshoot SQL Server Agent jobs
219
8
Questions
221
2
Answers
223
4
Configure alerts and operators by using SQL Server Agent
227
6
Questions
229
1
Answers
230
3
Optimize hardware resource usage
233
4
Questions
234
1
Answers
235
2
Optimize and troubleshoot SQL Server system activity
237
6
Questions
239
2
Answers
241
2
Glossary
243
10
Index
253