Programming SQL Server 2005
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 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 |