Programming SQL Server 2005 - page 124



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]

AcceptsPause property
AcceptsStop property
access
     Activity Monitor
     ADOMD.NET
     CAS
     SQL Native Client programming
     SQL Server Agent
     SQL Server Management Studio
     URL
     XMLA
accounts
     Database Mail
     email
     proxy, creating
     TestLogin SQL Server login
actions (job steps)
Activity Monitor, accessing
ad hoc query support
Add Database Reference dialog box
Add New Item dialog box
Add Stored Procedure menu item
Add Table dialog box
Add( ) method
adding
     connection managers
     connection strings
     tasks to packages
AddReplicatedColumns( ) method
addresses, managing URNs
ADF (application definition file)
administration
     SQL Server Management Studio
ADO.NET
     classes, disconnected enhancements
    data providers
         enhancements
         enumeration
     factories
     in-process extensions
ADOMD.NET, accessing data
AdomdConnection class
AdomdDataReader class
AdomdDataReader object
after keyword
agents
     history, retrieving
     managing 2nd
     replication
AgentSchedule.FrequencySubDay property
AgentSchedule.FrequencySubDayInterval property
AgentSchedule.FrequencyType property
AgentSubSystem enumeration
Alert Properties dialog box
alerts
     managing
     SQL Server Agent, creating
aliases, creating
ALL operator
ALTER ASSEMBLY statement
ALTER ENDPOINT statement
ALTER FUNCTION statement
ALTER INDEX statement
ALTER PROCEDURE statement
ALTER statement
ALTER TRIGGER statement
ALTER XML SCHEMA COLLECTION statement
Alter( ) method
aml data type (T-SQL)
AMO (Analysis Management Objects)
Analysis Services
     connecting
     event providers
     tasks
Analysis Services Scripting Language (ASSL) 2nd
analysis, workload
annotated mapping schemas
annotations
     HPA
ANY operator
application definition file (ADF)
applications
     ADO.NET data providers/factories
    databases
         enumerating
         managing
         Notification Services
     domains, CLR integration
    Notification Services
         architecture
         creating 2nd
         creating instances
         databases
         programming
     ReportViewer control
     roles
    SMO
         classes
         creating (in Visual Studio.NET)
     SQL Native Client
    SQL Server Mobile
         managing databases
         modifying databases
         prerequisites
         programming
         troubleshooting databases
         updating databases
     SSRS, integrating into
     statements, capturing
APPLY operator
applying
     parameters in queries
     variables in SSIS
architecture
     Notification Services
     Service Broker
     SSIS
Area( ) method
arguments
     BATCHES language-specific
     endPointName
     LIFETIME
     server_principal
articles
     creating
     filtering
     managing
AS SNAPSHOT clause
assemblies
     .NET Framework
         enumerating
     enumerating
     managing
     sys.assemblies catalog view
assignment
     constants
     permissions
ASSL (Analysis Services Scripting Language) 2nd
asynchronous programming
attributes
     CLR integration, customizing
     HPA
     SASS
     SqlFacet
     SqlFunction
     SqlMethod
     SqlProcedure
     SqlTrigger
     SqlUserDefinedAggregate
     SqlUserDefinedType 2nd
authentication
     endpoints
     replication
AUTHENTICATION clause
AUTO mode
AUTO_CREATE_STATISTICS database option
Axes property