Index_A

A

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