|
|
Absolute data type, 225
Access database, creating a linked server to, 306
Action tab (for alerts), 149-150
Active Directory, 16, 32
Active/active cluster, 26-27
Active/passive cluster, 376
ActiveX Script tasks, debugging, 130
Ad hoc queries against SQL Server. See Query Analyzer
Add Destination Database dialog box, 354-355
Administering DTS, 115-131
Administration (SQL Server), 93-131
automating tasks of, 165-208
centralized, 112-114
Administrative DBCC commands, 184-192
Administrative T-SQL, 172-203
Administrators group, 16
ADO in ASP, and text and image fields, 231
Advanced options (configuration), 36-38
Aged data, placing into read-only database, 246
Agent History, 453
Agent inactivity threshold, increasing, 453
Agents
troubleshooting, 453
used in replication, 424
Alert System tab (SQL Server Agent), 101
Alerting system, 72
Alerts, 157-159
configuring in System Monitor, 148-150
creating, 157-158
with sample interval of 30 seconds, 149
to send a message and start the log, 150
triggering, 145
Aliased table name, 321
Aliased server name, 214-215, 317
Allow Database To Assume Primary Role option, 356
Analysis Server, 30
Analysis Services, 27, 29
ANSI settings (SET commands), 191
Application components, prefixing for migration, 223
Application event log, 101
Apply Traces Among All Connections trace flag, 154
app_name() function, 192
Architecture overview (SQL Server), 5-6
Articles (in replication)
defined, 422
types of, 421-422
Ashton-Tate/Microsoft SQL Server, 4
Assign Drive Letter or Path screen, 385
Attaching a database, 54, 295-296
Attaching vs. restoring a database, 54
Audit Level row, 72
Audit tables, creating, 192
Auditing, 71-77, 89
C2-level, 38, 73-75
DBCC USEROPTIONS output for, 191-192
Auditing functions, 192-193
Auditing injection attacks, 89
Auditing level, changing, 72
Auditing package, 129
Auditing triggers, 192
Authentication modes, 33-34
Auto Close option, 45
Auto Create Statistics, 45-46
Auto Shrink option (Database Options), 42-43
Autogrow process (database growth), 218
Automating administrative tasks, 165-208
Autonomy, replication and, 421
Average server activity reports, 147-148
Avg. Page Density, 251
AWE (Address Windowing Extensions), 37-38
AWE mode, enabling, 38
|
|