-S switch, using with Sqlcmd, 38–39
SAFE permission, using with .NET database objects, 89
scalar values, extracting from XML data types, 149
Schedule element of ADF, description of, 116
scheduled tuning, support for, 43–44
Schema section of ADF, description of, 118
schemas. See also XSD schemas
creating database objects in, 16
defining for Notification Services applications, 110
definition of, 15
returning with XMLSCHEMA directive, 153–154
Script Wizard, using with Object Explorer, 29
scripting support, availability in Analysis Services, 221
scripting variables, defining with Sqlcmd, 38–39
scripts
Analysis Server scripts, 32
SQL Mobile scripts, 32
SQL Server scripts, 32
secondary XML indexes, creating, 150–151
security
of catalogs, 21
of dialogs in SQL Server Service Broker, 139–140
enhancements in Analysis Services, 224–225
and more granular permissions control, 19–20
of .NET database objects, 89
overview of, 14–15
and password policy enforcement, 20
and stored procedure execution context, 17–19
and user-schema separation, 15–17
Select Build Method window, displaying in Cube Wizard, 229
Select Measures window, displaying in Cube Wizard, 231
SELECT permission, description of, 20
SELECT statements
using with CTEs, 91
using with OPENXML, 155
using with PIVOT operations, 93
using with SQL Server Service Broker application, 135
Select Tables and Views window, displaying in Data Source View Wizard, 227
Select the Data Source window, displaying in Report Wizard, 176
Select the Report Type window, displaying in Report Wizard, 178
semicolon (;), using with WITH keywords, 91
SEND operations, executing in SQL Server Service Broker application, 136
SEND T-SQL DML statement, description of, 133
SENT BY clause, using in SQL Server Service Broker application, 134
server events, features of, 9
server failure, protection against, 50–55
Server Manager, absence of, 24
servers, registering with SQL Server Management Studio, 28
server-side cursors, ADO.NET support for, 97–98
Service Broker. See SQL Server Service Broker
service instances. See conversation groups
services
creating for SQL Server Service Broker application, 135
grouping contracts as, 132
SET statement, using with UDTs, 84–85
SET WITNESS clause, using with Database Mirroring, 54
sets, using in WHERE clause with MDX, 236
Sharepoint versus Report Manager, 172
Showplan, example of, 41
single quotes (‘), using with CREATE XML SCHEMA COLLECTION DDL statement, 144–145
SINGLE_CLOB argument, using with XML bulk load, 156
SMO (SQL Server Management Objects), features of, 46–47
SMP systems, relationship to NUMA, 6
Snapshot Isolation, features of, 61–62
Snapshots, support for, 8
Solution Explorer window
in Business Intelligence Development Studio, 35–37
in Report Designer, 167
in SQL Server Management Studio, 30–32
source control feature
in Business Intelligence Development Studio, 37
in SQL Server Management Studio, 32–33
Source* system variables, purpose in Integration Services, 196
sp_configure, options for, 139
SQL Server 2000, ownership chains in, 18
SQL Server Computer Manager
availability in Analysis Services, 221
features of, 24–25
using with Analysis Services, 222
SQL Server engine enhancements
bulk data loading, 13–14
data partitioning, 10–12
database data files, 9
Database Snapshots and Mirroring, 8
Full-Text search, 14
indexes, 12
MARS (Multiple Active Results Sets), 13
for multiple instances, 7
.NET framework integration, 7
new data types, 7–8
server events and DDL triggers, 9
system catalog and metadata, 12–13
T-SQL query processor, 14
SQL Server Enterprise Manager, replacement of, 25
SQL Server event providers, relationship to Notification Services, 108
SQL Server Management Studio
creating Notification Services applications with, 121
Current Activity window in, 33
Dynamic Help window in, 32
guidelines for use of, 37–38
Object Explorer window in, 27–29
overview of, 25–29
Properties window in, 32
Query Editor in, 29–30
Registered Servers window in, 27–28
relationship to XML bulk load feature, 156
Results window in, 30
Solution Explorer in, 30–32
source control feature in, 32–33
using with Analysis Services, 223–224
SQL Server Management Studio Query Editor. See Query Editor
SQL Server .NET Data Providers. See .NET data providers
SQL Server Project template, using with .NET data providers, 70
SQL Server projects. See projects
SQL Server scripts, using with Solution Explorer, 32
SQL Server Service Broker
activating, 130
administering, 138–140
conversation groups in, 129–130
and dialog security, 139–140
dialogs in, 128–129
and DML statements, 132–133
example application for, 133–138
features of, 126–127
and message transport, 130–131
programming model for, 131–132
queue application design of, 127–128
system views in, 140
and T-SQL DDL, 132–133
SQL Server systems, registering, 28
SQL Server templates. See templates
SqlBulkCopy object, ADO.NET support for, 102–103
Sqlcmd utility
features of, management and development tools, 38–40
starting in dedicated administrative mode, 60
SqlDataReaders, assigning ADO.NET’s asynchronous queries to, 99
SqlPipe ADO.NET objects, using with UDTs, 79
[SqlProcedure] attribute, using with .NET stored procedures, 74
SqlResultSet object, ADO.NET support for, 97–98
SqlServerSystem tag in config.xml file, significance of, 113
SqlTriggerContext ADO.NET objects, using with UDTs, 79
StartTime system variable, purpose in Integration Services, 196
state, maintaining with service instances, 129
stored procedure execution context, relationship to security, 17–19
stored procedures
creating by activation, 130
relationship to .NET CLR, 72
using to retrieve messages from queues, 136–138
using with SQL Server Service Broker application, 135
strongly typed XML data types, overview of, 143–147. See also XML data types
SubLocale section of ADF, description of, 118
Subreport control, using with Report Designer, 166
subscribers, adding to Notification Services applications, 123–124
subscription delivery, implementing with Report Server, 171
subscription management interface, providing for Notification Services, 111–112
Subscription objects, using with Notification Services, 124
SubscriptionClasses section of ADF, description of, 118
subscriptions in Notification Services
adding, 108
overview of, 107
summary line, displaying in Reporting Services reports, 185
Sys.* views in SQL Server Service Broker, descriptions of, 140
sys.assemblies view, viewing assemblies with, 69
system catalog, enhancements in, 12–13
system configuration options, using with SQL Server Service Broker, 139
system variables, Integration Services support for, 195–196
system views, availability in SQL Server Service Broker, 140
System.Data.SqlClient namespace, relationship to ADO.NET’s asynchronous queries, 99
System.Data.SqlServer namespace
contents of, 72
importing, 74
sys.Types view, querying, 84
sys.xml* catalog views, descriptions of, 158
sys.xml_namespaces system view, querying, 146