The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit

Index

A

• accent sensitivity, 247

• ADDRESS parameter, 540

• Address Windowing Extensions (AWE), 104

• ad hoc distributed queries

  • enabling, 339–340

  • OPENDATASOURCE function

    • basic syntax for, 348

    • querying data with, 349

  • OPENQUERY function

    • basic syntax of, 353

    • querying data with, 354

  • OPENROWSET function

    • basic syntax of, 343

    • for bulk loading data, 347

    • copying data with, 346

    • database.schema.object identifier, 343

    • modifying data with, 346

    • problem with, 353

    • querying data with, 344–345

    • table-valued function, 342

    • XML file, 347–348

• administrator account, 61

• Advanced tab, 93

• AdventureWorks2008 database

  • bulk operations and recovery model, 335

  • querying data from a table in, 338–339

  • schemas, 133

• AES algorithm, 538

• alias

  • creating, 99–100

  • managing, 99

• ALL_ERRORMSGS ...