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)
|
Ajax Editor
Ajax development