A

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

-A option (SQLCMD)
access restrictions
Account Retry Attempts parameter
Account Retry Delay parameter
accounts
     proxy
     services
Action templates
Actions, DTA, Start Analysis menu command
Activity Monitor
     auto-refresh functionality
     blocked processes
     filtering
     last executed commands, viewing
     Locks by Object page
     Locks by Process page
     overview
     Process Info page
     starting
     user connections, killing
ad hoc queries
     data mining
     remote
$(A-DBN) token
Add Filter dialog box
Add Join dialog box
Add Publisher dialog box
Add SSIS Connection Manage dialog box
adding
     joins to tables
     packages to projects
     Publishers
ADFs (application definition files)
administration
     multi-server
     replication (Management Studio)
         agents
         configuring
         Object Explorer icons
        publications [See Database Engine, Agent, replication; administration, replication (Management Studio), publications.]
         Replication folder
        subscriptions [See Database Engine, Agent, replication; administration, replication (Management Studio), subscriptions.]
administration and management tools
     BCP
         architecture
         bulk import optimizations
         command syntax
         error handling
         exporting data
         exporting/importing example
         format files
         importing data
         improvements
         new features
         overview
         parameters
    Management Studio [See Management Studio.]
     OSQL
     query editors
         architecture
         Database Engine support
         fonts/colors
         Grid Control
         Grid Storage
         hotkeys
         Management Studio
         Mobile queries
         overview
         queries, executing
         Sort View
         SQLCMD
         starting
         Storage View components
         XML support
     Report Manager 2nd
    SQLCMD [See SQLCMD.]
Administrator Console (MOM)
Advanced Replay Options dialog box
Advanced System Properties Windows dialog box
AdventureWorks database
$(A-ERR) token
Agent
     architecture
     Database Engine monitoring
     error log file
     jobs
         Activity Monitor
         assigning to target servers
         creating
         history
         replication maintenance
         schedules
         starting
         steps 2nd
         Windows Performance Monitor
     Mail
     metadata tables
     monitoring capabilities
         event alerts
         mechanism
         operators
         performance alerts
         WMI alerts 2nd
     multi-server administration
     replication
     security
         database roles
         job steps, logging
         proxy accounts
     services, configuirng
     stored procedures
     synchronization script automation
     task types supported
     upgrades
Alert drill-down (MOM Operator Console)
alerts
     event
     performance
     WMI 2nd
Alerts view (MOM Operator Console)
algorithm (Data Mining)
Align command (BIDS Format menu)
All Subscriptions tab (Transactional Publication detail pane)
AMO (Analysis Management Objects)
     overview
     Surface Area Configuration tool dependency
$(A-MSG) token
Analysis Server Properties dialog box
Analysis Services
     BI Development Studio
         Action templates
         auto-scrolling
         Calculation templates
         changes, documenting
         Cube Browser filter components
         cubes, creating
         cubes, definitions
         cubes, prototyping
         dimensions, creating
         dimensions, definitions
         dimensions, types/attribute types
         KPI browser, rebuilding
         KPI company health indexes
         KPI Display folder
         KPI parent property
         KPI templates
         MDX debugger 2nd
         measure groups dimensionality, comparing
         measure groups granularity
         object documentation, viewing
         partitions 2nd
         project deployment
         Project mode versus Immediate mode
         quick cube/dimension designs/testing 2nd
         sample measures, viewing
         security
         time intelligence templates
         translations, loading
         upgrading AS2K cubes to AS2K5
         Visual Studio environment, customizing
     data mining
         algorithms/viewers
         association rule filters
         base columns with varying settings/properties
         classification matrix reports 2nd
         data source view, customizing
         diamond symbols
         lift chart
         multiple similar base columns
         productivity enhancements
         stored procedures, viewing
         viewer graphs, copying
     Deployment Wizard
     Dimension Editor tree views
     dimensions with multiple parents rollup with weights
     features, enabling/disabling
         ad hoc data mining queries
         anonymous connections
         linked objects
         user-defined functions
     installing
     multiple MDX queries
     OLAP tools
         BI Development Studio 2nd
         Management Studio
     overview
     process options
     Properties dialog box
     server properties, finding
     time dimensions, creating
     UDM 2nd
     upgrades
         enhance
         migration
         options
         rebuilding
anonymous connections
APIs (application programming interfaces)
     Notification Services
     Replay Objects
     Trace Objects
         saving trace tables to files
         saving traces to tables
         starting traces
         trace objects
application definition files (ADFs)
architecture
     Agent
     BCP
     Configuration Manager
     DTA
     Notification Services
     Query Editor
     SMO
     Surface Area Configuration tool
     Upgrade Advisor
argumentkey option (nscontrol create command)
arguments, encrypting
Article Properties dialog box
Articles page (New Publication wizard)
     properties
     table properties
AS2K cubes, upgrading to AS2K5
$(A-SEV) token
assemblies
association rules
     data mining stored procedure
     filters
$(A-SVR) token
asymmetrical reports
Attach dialog box
attributes
     dimensions
     relationships
Auto Layout command (BIDS Format menu)
auto-scrolling
Autobuild