S

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]

-S option (SQLCMD) 2nd
SAC command line utility
     remote computers
     services, stopping
     surface area settings, copying
sample databases, installing
sample measures, viewing
Save As command (SSIS Designer File menu)
Save As Trace Template command (Profiler File menu)
Save Copy of As command (SSIS Designer File menu)
Save Copy of Package dialog box
saving
     packages
     Profiler templates
     trace data
         files/databases
         tables
     trace tables to files
scale-out configuration (Reporting Services)
scheduling
     Agent tool
         architecture
         Database Engine monitoring
         error log file
        jobs [See Microsoft, Operations Manager, Agent; Database Engine, Agent, jobs.]
         Mail
         metadata tables
        monitoring [See Microsoft, Operations Manager, Agent; scheduling, Agent tool, monitoring.]
         multi-server administration
         replication
         security
         services, configuring
         stored procedures
         synchronization script automation
         task types supported
         upgrades
     events
     jobs
     management dialog boxes
     Snapshot Agent
     tasks
schema tools
Script Generation phase (SMO scripting)
scripter classes
scripting
     callback function
     multiple objects
     multiple phases
         C#.Net
         Dependency Discovery
         List Generation
         Script Generation
         Visual Basic.Net
     Object Explorer
     single phase
     SQLCMD startup
     TSQL
scripting options (SQLCMD)
scripting variables (SQLCMD) 2nd
secure by default feature
security
     Agent
         database roles
         job steps, logging
         proxy accounts
     certificates
     Database Engine 2nd
     Database Mail
     dimensions
     packages
     reports
     roles
     secure by default feature
     surface area
     upgrades
     Windows Integrated Security
security options (SQLCMD)
Security Property dialog box
Select Computer dialog box
sending email
     Database Mail
     SQL Mail
serious errors, sending to Microsoft
server-level commands (Notification Services)
serverlist command (SQLCMD) 2nd
servers
     blocked processes
     clustered
     DACs
     events, SMO monitoring
         external customizations
         index creation events
         table create/drop events
     master
     monitoring with Profiler
     MRU names
     Object Explorer, connecting/disconnecting
     properties
     registered
         adding to export files
         copying between users/computers
         friendly names
         grouping
         importing
         server status
         updating
         window
     status 2nd
     surface area
         Analysis Services features, enabling/disabling
         configuring
         Database Engine features, enabling/disabling
         disabling remote connections
         Reporting Services features, enabling/disabling
         shutting down unused components
     target
Service Broker
Service Pack Level
services
     accounts/passwords
     advanced settings 2nd
     Agent
     Analysis
         ad hoc data mining queries, enabling/disabling
         anonymous connections, enabling/disabling
        data mining [See installation and upgrade tools, Installation Wizard, Analysis Services; services, Analysis, data mining.]
         Deployment Wizard
         Dimension Editor tree views
         dimensions with multiple parents rollup with weights
         features, enabling/disabling
         installing
         linked objects, enabling/disabling
         multiple MDX queries
        OLAP tools [See BIDS (Business Intelligence Development Studio); Management Studio.]
         overview
         process options
         Properties dialog box
         server properties, finding
         time dimensions, creating
         UDM 2nd
         upgrades 2nd
         user-defined functions, enabling/disabling
     clustered
     components
     configuring
     customer feedback reporting
     discovery
     dump directory
     error reporting
     instance IDs
     Integration
         adding packages to projects
         BIDS 2nd 3rd
         breakpoints
         connection managers
         connections
         control flow
         data flow
         data sources
         debugging
         deployment utility, configuring
        Designer [See SSIS Designer.]
         ETL
         importing/exporting packages
         installing
         installing packages 2nd
         named instance connections
         overview 2nd 3rd
        packages [See installation and upgrade tools, Installation Wizard, Integration Services; services, Integration, packages.]
         precedence constraints
         project source control
         property expressions 2nd 3rd
         read/write permissions
         source control
         Stored Packages folder
         subfolders, customizing
         working offline
     languages
     monitoring
     Native XML Web
     Notification
         APIs
         applications 2nd
         architecture
         Configuration Manager
         disabling instances
         enabling/disabling applications/instances
         engine
         installing
         Instance dialog box
        instances [See deploying, instances, Notification Services; services, Notification, instances.]
         logging levels
        Management Studio [See deploying, instances, Notification Services; services, Notification, Management Studio.]
         metadata, exporting
         Notification Services engine
        NSControl command line utility [See NSControl command line utility.]
         overview 2nd
         performance
         Registry, updating
         resources
         stored procedures
         subscription rules, customizing
         summary reports
         Surface Area Configuration Manager
         views
         Windows Event Viewer
         Windows services, starting/stopping
     Registry root
     Reporting
         asymmetrical reports
         Configuration tool 2nd
         configuring
         data mining queries 2nd
         data sources, choosing
         deploying reports
         features, enabling/disabling
         installing
         KPIs, viewing
         languages, choosing
         managing in Management Studio
         OLAP/relational data source combinations
         optimization
         overview
         Report Builder
         report deliveries, enabling/disabling
         Report Designer
         Report Manager
         reports, creating
         scheduled events, enabling/disabling
         security
         setup
         Web Service and HTTP Access, enabling/disabling
         Windows Integrated Security, enabling/disabling
     Service Pack Level
     starting
     startup parameters
     Stock Keeping Unit Name
     stopping 2nd
     versions
     viewing
     virtual server names
     Web, enabling/disabling
     Windows, starting/stopping
Session Monitor (DTA)
Set Breakpoints dialog box
Set Values page (Execute Package utility)
Setup tool
Setup Wizard
setvar command (SQLCMD) 2nd
severity levels (errors)
shared memory objects
Short Message Service (SMS)
side-by-side migration 2nd
Simple Mail Transfer Protocol (SMTP)
single phase scripting
single user mode (Database Engines)
SMO (SQL Server Management Objects) 2nd 3rd
     architecture
     assemblies
     Capture Mode
     classes
     database backups
     diagram
     full text indexes, deleting
     local trees
     logins, creating
     namespace references
     optimized instantiation
     overview
     pre-fetch
     restoring databases
     scripting
         callback function
         multiple phases
         single phase
     server events, monitoring
         external customizations
         index creation events
         table create/drop events
     Surface Area Configuration tool dependency
     tables, customizing
SMS (Short Message Service)
SMTP (Simple Mail Transfer Protocol)
Snapshot Agent page (New Publication wizard)
Solution Explorer
Solution Explorer command (Management Studio View menu)
solutions, defined
Sort View (Query Editor)
source control (projects)
SP_Counts template (Profiler)
sp_process_mail stored procedure
sp_send_dbmail stored procedure
SQL Agent Properties dialog box
SQL Mail
     configuring
     enabling/disabling 2nd
     extended MAPI
     mail
         deleting
         reading
         sending
     mail profiles
     overview 2nd
     stored procedures
SQL Management Objects [See SMO (SQL Server Management Objects).]
SQL Server 2000
SQL Server 2005
     installing 2nd
         Analysis Services
         Books Online
         Database Engine 2nd 3rd
         deleting components
         editions, choosing
         existing instances
         instances 2nd
         Integration Services
         Notification Services
         post-installation tasks
         pre-installation tasks
         Reporting Services
         sample databases
         Setup tool
         Setup Wizard
         workstation components
     SQL Server 2000, compared
     upgrade
         backward compatibility issues
         in-place upgrades
         planning
         post-upgrade tasks
         preparations
         Report Viewer
         side-by-side migration
         Upgrade Advisor
SQL Server Integrations Services [See Integration Services.]
SQL Server Management Objects [See SMO (SQL Server Management Objects).]
SQL Server permissions
SQL-DMO (SQL Distributed Management Objects)
SQLAGENT.OUT file
SQLAgentOperatorRole database role
SQLAgentReaderRole database role
SQLAgentUserRole database role
SQLCMD
     commands
         !!
         case sensitivity
         colorizing
         ED
         ERROR
         examples
         executing by Query Editor
         EXIT
         GO
         LIST
         LISTVAR
         not supported by Query Editor
         ON ERROR
         OUT
         overview
         PERFTRACE
         QUIT
         r
         RESET
         SERVERLIST
         SETVAR
         XML
     options
         -A
         -b
         -d
         -E 2nd
         -f
         -h
         -I
         -i input_file
         -k
         -L
         -m error_level
         -o output_file
         -P 2nd
         -q
         -r 2nd
         -S 2nd
         -t
         -U 2nd
         -V 2nd
         -w
         -x
         -y
         case sensitivity
         command execution
         command line
         connection
         error handling
         file stream
         formatting
         language-specific
         redirection
         reporting
         scripting
         security
     overview
     Query Editor
         colorizing commands/variables
         commands not supported
         executing scripts
         redirecting results/errors
         turning on/off SQLCMD feature
     scripting variables
     startup script
SqlConnectionInfo object
$(SQLDIR) token
sqlpassword option (nscontrol create command)
sqlusername option (nscontrol create command)
$(SRVR) token
SSIS (SQL Server Integrations Services) [See Integration Services.]
SSIS Designer
     Connection Managers area
     Control Flow tab
     Data Flow tab
     Event Handlers tab
     Format menu
     menu options
     Package Explorer tab
     packages
         control flow
         copying/pasting
         creating 2nd
         saving
     Progress tab
Standard Edition
Standard template (Profiler)
Start Analysis command (DTA Actions menu)
Start command (Notification Services)
starting
     Activity Monitor
     Administrator Console
     Configuration Manager
     Database Engine
     DTA
     instances
     jobs
     New Publication wizard
     Query Editor
     Replay
     Replication Monitor
     services 2nd
     traces 2nd
     Usage and Error Reporting Configuration tool
     Windows Services
startup parameters
     Database Engine
     services
startup scripts (SQLCMD)
State view (MOM Operator Console)
state, monitoring
statements (generated)
status overlays (Replication Monitor)
$(STEPCT) token
$(STEPID) token
Stock Keeping Unit Name property (services)
Stop command (Notification Services)
stopping
     instances
     services 2nd
     tracing
     Windows services
storage (Database Mail)
Storage View components (Query Editor)
Stored Packages folder (Integration Services)
stored procedures
     Agent
     data mining 2nd
         association rule
         clustering
         decision trees
         dependency net
         Naive Bayes
         neurel net
     Notification Services
     NSAdministrationHistory
     NSEventBatchDetails
     NSEventBatchList
     NSNotificationBatchDetails
     NSNotificationBatchList
     NSScheduledSubscriptionDetails
     NSScheduledSubscriptionList
     NSSnapshotApplications
     NSSnapshotDeliveryChannels
     NSSnapshotEvents
     NSSnapshotProviders
     NSSnapshotSubscriptions
     NSSubscriptionConditionInformation
     NSVacuum
     SQL Mail
     xp_cmdshell
$(STRTDT) token
$(STRTTM) token
Submitting Configuration Information phase (DTA)
Subscription Watch List tab
     Merge Publication detail pane
     Publisher Detail Pane
subscriptions
     creating 2nd
     identifying
     merge
     rules (Notification services)
     tooltips
     transactional
     viewing
subsystems
     msdb.dbo
     viewing
summaries
     packages
     reports (Notification Services)
Summary tab (Management Studio)
Summary Window
surface area
     Configuration tool
         Analysis Services features
         architecture
         categories
         command line
         Database Engine features, enabling/disabling
         GUI
         instances/components, identifying
         overview
         remote computers
         Reporting Services features, enabling/disabling
         security
         starting services
         stopping services 2nd
         surface area settings, copying
         surface area, reducing 2nd
         viewing services
     configuring
     reducing
         Analysis Services features, enabling/disabling
         Database Engine features, enabling/disabling 2nd
         disabling remote connections
         Reporting Services features, enabling/disabling
         shutting down unused components
     remote computers
     servers
     settings
Surface Area Configuration for Features dialog box
Surface Area Configuration for Services and Connections tool
Surface Area Configuration Manager (Notification Services)
Surface Area Configuration tool 2nd
Synchronize button (Summary window toolbar)
Synchronize Database Wizard
System Monitor (Notification Services)