S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

Samples directory
scalability
     SQL-NS application models 2nd 3rd
     user-defined logic
scalability (notification applications)
     capacity limitations (input/output systems) 2nd
     overview 2nd
     subscription matching costs 2nd
scalability features (Enterprise Edition) 2nd
scaling out
     SQL-NS servers 2nd
scaling up
     SQL-NS servers 2nd
schedule rules
     [brkt-]ConditionAction[-brkt] element
scheduled event providers
     troubleshooting 2nd
scheduled event providers. 2nd [See also event providers] [See also custom hosted event providers]
scheduled hosted event providers
     assemblies, building 2nd
     declaring 2nd
     operation of 2nd
     overview 2nd
    ScheduledHostedEventProvider class
         Initialize() method 2nd 3rd
         overview
         Run() method 2nd 3rd
         Terminate() method 2nd 3rd
     testing 2nd
scheduled rules
     event and scheduled rules interaction 2nd
     music store application 2nd 3rd
     user-defined logic rule processing
scheduled subscription class
     overview
     scheduled rules 2nd 3rd
     schema for subscriptions by genre 2nd
     subscription chronicles 2nd
     subscription states 2nd
scheduled subscription debugging stored procedures
     NSScheduledSubscriptionDetails 2nd
     NSScheduledSubscriptionList 2nd
     overview
     scheduled subscriptions, adding 2nd
scheduled subscriptions
     adding for debugging stored procedures 2nd
     music store application
     music store database 2nd 3rd
     testing 2nd 3rd
     times zones, troubleshooting 2nd
     user-defined logic
scheduled subscriptions. [See also state maintenance]
ScheduledHostedEventProvider class
     Initialize() method 2nd 3rd
     overview
     Run() method 2nd 3rd
     Terminate() method 2nd 3rd
ScheduleRecurrence properties 2nd
ScheduleStart properties 2nd 3rd 4th
schema
     user-schema separations 2nd
schema qualified names
     music store application 2nd
schema-qualified names
SchemaFile argument
schemas
     as namespaces
     event-triggered subscriptions 2nd
     FileSystemWatcherProvider 2nd 3rd
     for events
     for notifications
     for subscriptions
     music store database 2nd
    notification schemas
         application development process 2nd
     SQL-annotated schemas 2nd
     subscriptions by genre 2nd
     XSD schemas
schemas. 2nd [See also ADF [NPN]] [See also ADFs (Application Definition Files)]
scoping events
scoping of data
scripts
     deployment security and 2nd
Scripts directories
     setenv.cmd file 2nd
Scripts subdirectories 2nd
SecondaryGroup filegroup
security
     content formatters 2nd
    event providers
         argument encryption 2nd 3rd 4th
         argument keys 2nd 3rd 4th 5th 6th
         database roles 2nd
         overview 2nd
    user accounts
         development process 2nd
    user-defined logic
         overview 2nd 3rd
         sample application 2nd 3rd
security (notification applications)
     overview 2nd
security policies (deployment security)
security sandboxes
     user-defined logic security
security violations
     exceed throttles, troubleshooting
security vulnerabilities (deployment configurations). [See deployment security]
SELECT clauses
     purpose of
SELECT permissions
     user-defined logic security
semantic errors
     in rules 2nd
separate physical disks
separate physical disks (database systems)
Server class
     legacy support
server farms
server login
     user-defined logic security 2nd 3rd
ServerConnection class
     AddSubscriptions program
     StockBrokerNMO sample
ServerInstance property
     StockBrokerNMO sample
service accounts
     creating 2nd 3rd
setenv.cmd
     development environments, testing
     environment variables, setting up 2nd
setenv.cmd files 2nd
setup (SQL-NS)
     on deployment machines 2nd
setup all.cmd
setup wizard
     installing SQL Server components 2nd
shema-qualified names
     [brkt-]Database[-brkt] element
signed assemblies
     deployment security
simple leaf conditions
simple recovery models (database systems) 2nd
SimpleLeafCondition property
SimpleOperator enumeration
single machine deployment
     overview 2nd
skeleton ADFs 2nd
     adding code to 2nd
     compiling 2nd 3rd 4th
skipped quantums
SMI
     subscription schedules, restricting
SMI (Subscription Management Interface)
     condition-based logic
SMIs
     deployment process 2nd
    sample applications. [See AddSubscriptions program]
     separating from event providers 2nd
    user-defined logic
         Condition APIs 2nd
         Condition APIs. [See also Condition APIs]
         overview 2nd
SMIs (Subscription Management Interfaces)
     administrative functions
     architecture of 2nd
    data layer
         connecting to the logic layer 2nd
         description of 2nd
    logic layer
         codes 2nd
         connecting to the data layer 2nd
         description of 2nd
         implementing 2nd
         operations 2nd
         purpose of 2nd
    membership providers (ASP.NET)
         database objects, creating for 2nd
    MusicStoreSMIOperations class
         Genres property 2nd
         GetNewSongByArtistSubscriptions() function 2nd
         GetNewSongByGenreSubscriptions() function 2nd
         overview
         SubscriberExists() function 2nd
         Subscribers property 2nd
         TimeZones property 2nd
     overview 2nd
    subscriber device operations
         adding subscriber devices 2nd
         overview
         removing subscriber devices 2nd 3rd
    subscriber operations
         overview 2nd
    subscriber records
         modifying 2nd
         overview 2nd
         removing 2nd 3rd
    Subscription class
         Add() method 2nd
         AddNewSongByArtistSubscription() method 2nd 3rd
         AddNewSongByGenreSubscription() method 2nd
         Delete() method 2nd
         FormatScheduleStart() method 2nd
         index operator ([])
         overview 2nd
         ScheduleRecurrence properties 2nd
         ScheduleStart properties 2nd
         TimeZoneId property
         ToString() method
         Update() method 2nd
     types of 2nd
    user-interface layer
         description of
    Visual Studio solutions
         overview 2nd
SMIs (subscription management interfaces)
     discontinued use of
SMIs (Subscription Management Interfaces). 2nd 3rd [See also Subscriber Management APIs] [See also Subscriber Management APIs [NPN]] [See also user interfaces [NPN]]
SMO
     AddSubscriptions program
SMO APIs
     AddSubscriptions program
SMO classes
    obtaining
         AddSubscriptions program 2nd
    obtaining for
         AddSubscriptions program
SMOs
     reflections (NMO) 2nd
SMOs (SQL Server Management Objects). 2nd [See also NMO]
SMTP delivery channels
     creating 2nd 3rd 4th 5th
SMTP delivery protocol
     utilizing 2nd
SMTP delivery protocols
    declaring
         support in the Notification classes 2nd 3rd
     testing 2nd 3rd
SMTP delivery protocols. [See also delivery protocols]
SMTP Service
     installing 2nd
SmtpServer argument
     local machine names, specifying
snapshot reports 2nd
Solution Explorere window (Management Studio)
SongAlerts application
     connecting AddSubscriptions program to 2nd
source code
     installing 2nd
source code base directories 2nd
source code controls
     backing up
source codes
     deployment security and 2nd
source files (development environments), customizing 2nd
spam
     versus publisher-subscriber models
SQL Client components
     installing on deployment machines
SQL compiler
     development process
SQL connectivity errors
     event submission, troubleshooting
SQL Engine components
     installing on deployment machines
SQL errors
     event submission 2nd
SQL expressions
     computed fields 2nd
SQL joins
     matching with 2nd 3rd
SQL passwords
     hosted engines 2nd
SQL Server
     seperating from the engine 2nd
     unable to connect/log in errors 2nd
SQL Server 2003 Notificiation Services. [See SQL-NS]
SQL Server 2005 Management Studio
     development process 2nd
SQL Server 2005 Notification Services. [See also Notification Services]
SQL Server Agent
     cleanup jobs, setting up
SQL Server Authentication
     deployment security
     hosted engines 2nd
     unable to connect/login errors
SQL Server authentications
     development accounts 2nd
     development process 2nd
     setting up 2nd
     test accounts 2nd
SQL Server Configuration Manager
     instances, starting 2nd
SQL Server Event Provider. [See SQLProvider]
SQL Server Management Objects (SMO). [See SMOs]
SQL Server Management Objects. [See SMOs]
SQL Server program group
     contents of
SQL Servers
     various meanings of term
     versus development machines
SQL statements
    [brkt-]SQLExpression[-brkt] element
         overview 2nd 3rd 4th 5th
SQL usernames
     hosted engines 2nd
SQL usernames and passwords
     deployment security 2nd
SQL-annotated schemas 2nd
SQL-NS
     2005 new features 2nd
     description of
     features overview 2nd 3rd
     non-starts, troubleshooting 2nd
    notification applications
         build benefits 2nd
         declarative programming frameworks
         engine execution
         execution engines
         framework extensibility
         rich application features
         speed of development
     official website 2nd
SQL-NS API. [See Subscriber Management APIs]
SQL-NS application models
    user-defined logic. [See user-defined logic]
SQL-NS applications
     overview
     parts of 2nd
SQL-NS applications. [See also application development process]
SQL-NS assembly
     browsing for
     overview 2nd
     referencing
SQL-NS assembly. [See also Subscriber Management APIs]
SQL-NS base diretories. [See source code base directories]
SQL-NS Books Online
     class reference
     performance objects
     subscriber locales
SQL-NS compiler
     parameters
SQL-NS compilers
     ADFs elements
     ICFs (Instance Configuration Files)
SQL-NS condition models
    user-defined logic
         overview 2nd
SQL-NS engine
    distributors
         overview 2nd
     hosted event providers. 2nd [See also event providers]
SQL-NS engines
     seperating from the server 2nd
SQL-NS engines. [See engines]
SQL-NS execution engine
     multiple server instance deployment
SQL-NS execution engines
     component configuration purpose
SQL-NS installation
     on deployment machines 2nd
SQL-NS licensing FAQ
SQL-NS namespace
     Subscription Management API classes 2nd
SQL-NS public newsgroup
SQL-NS Redistributable Package
     Client Components, installing
SQL-NS services
     automatic startup
SqlCommand objects
     scheduled hosted event providers
SQLPermissions.sql
SQLProvider
     [brkt-]Arguments[-brkt] element
     [brkt-]HostedProvider[-brkt] declaration
     [brkt-]HostedProvider[-brkt] element 2nd
     [brkt-]Interval[-brkt] element 2nd
     [brkt-]Schedule[-brkt] element 2nd
     [brkt-]StartTime[-brkt] element
     chornicles 2nd
     events queries 2nd 3rd
     overview 2nd
     PostQuery arguments
     testing 2nd
     troubleshooting
     versus stored event submission procedures
standalone event providers
     advantages of 2nd
     building 2nd
     configuring in ADFs 2nd
    event submission
         from applications 2nd 3rd 4th
         with stored procedures 2nd 3rd 4th
     overview 2nd
    XML event providers
         code for 2nd
         design of 2nd
         LoadXml() method
         Main() method 2nd 3rd
         overview 2nd
         testing 2nd
         ValidateArguments() method 2nd
Standard versus Enterprise Editions 2nd
start engine programmatically (EngineHost program)
StartCollectionTime column (event batch tables)
starting services (deployment process) 2nd
StartInstance() method
     hosted engines 2nd
state mainetenance
    event chronicles
         declaring 2nd
         overview 2nd
         schema qualified names 2nd
         testing 2nd
    event chronicles rules
         overview 2nd
     overview 2nd
    subscription chronicles
         music store application 2nd
    subscription states
         music store application 2nd
statement orders
     in property rules)
StockBrokerNMO
     Hosting APIs 2nd 3rd
StockBrokerNMO sample
     overview 2nd 3rd
     testing 2nd
StockBrokerNMO sample. [See also NMO]
StockWatcher application, defining. [See also NMO]
StockWatcher application. [See notification applications]
StopInstance() method
     hosted engines 2nd
stored event submission procedures 2nd 3rd 4th
stored procedures
     debugging
    reporting stored procedures
         analysis reports 2nd
         diagnostic reports 2nd
         overview 2nd 3rd
         snapshot reports 2nd
     submitting events with 2nd 3rd 4th
strict event batch ordering 2nd 3rd
StringDictionary classes
strong names
     installing in Global Assembly Cache (GAC)
strong names (deployment security)
submission (event). [See event submission]
submissionThread variables (continuous hosted event providers)
submitEvents variable
subquantum ordering. [See also strict event batch ordering]
Subscriber class (Subscriber Management API) 2nd 3rd
subscriber data 2nd
subscriber device names
     troubleshooting 2nd
subscriber device operations (SMI logic layer)
     adding subscriber devices 2nd
     overview
     removing subscriber devices 2nd 3rd
subscriber device table
subscriber devices
     adding for delivery channels 2nd
     Subscriber Management APIs 2nd
    troubleshooitng
         incorret configurations 2nd
     troubleshooting 2nd
     user-defined logic
subscriber devices names
    troubleshooitng
         incorret match rule insertion of 2nd
subscriber locale tables
subscriber locales
     user-defined logic
Subscriber Management API
     classes 2nd 3rd
    setting up
         overview 2nd
    SQL-NS assembly
         overview
Subscriber Management APIs
     data permission (subscription management) 2nd 3rd
     fundamental entities in 2nd
     overview
    SQL-NS assembly
         browsing for
         overview
         referencing 2nd
     SQL-NS instance, preparing 2nd
Subscriber Management APIs. [See also SMIs (Subscription Management Interfaces) [NPN]]
subscriber operations (SMI logic layer)
     overview 2nd
    records
         modifying 2nd
         overview 2nd
         removing 2nd 3rd
SubscriberDevice class (Subscriber Management API)
SubscriberDeviceEnumeration class (Subscriber Management API)
SubscriberEnumeration class (Subscriber Management API) 2nd
SubscriberEnumeration classes 2nd
SubscriberEnumeration classes. [See also MusicStoreSMIOperations class]
SubscriberExists() function 2nd
SubscriberID property ( SMIs logic layer) 2nd
subscribers
    adding
         with T-SQL scripts 2nd
    device/locale specific subscribers
         adding 2nd
     Subscriber Management APIs
Subscribers property (MusicStoreSMIOperations class) 2nd
subscribers. [See subscriptions]
subscribtions
    device/locale specific subscribtions
         adding 2nd
subscripiton classes
    defining
         for user-defined logic 2nd
subscription chronicles
     cleanup 2nd
     music store application 2nd
         overview 2nd
Subscription class
     Condition APIs
     generality of
Subscription class (SMI logic layer)
     Add() method 2nd
     AddNewSongByArtistSubscription() method 2nd 3rd
     AddNewSongByGenreSubscription() method 2nd
     Delete() method 2nd
     FormatScheduleStart() method 2nd
     index operator ([])
     overview 2nd
     ScheduleRecurrence properties 2nd
     ScheduleStart properties 2nd
     TimeZoneId property
     ToString() method
     Update() method 2nd
     versus subscription classes
Subscription class (Subscriber Management API)
subscription class schemas
     device/locale information, storing 2nd
subscription classes
    enumerating
         with NMO 2nd 3rd 4th
    event-triggered subscriptions
         declaring 2nd
     user-defined logic support 2nd
         overview 2nd
     versus Subscription class
subscription conditions. [See also conditions]
subscription data
     normalizing 2nd
     restoring
subscription management API
     notification application phases
Subscription Management APIs
     logic layer (SMI) wrapping
Subscription Management Interfaces, [See SMIs (Subscription Management Interfaces) [NPN]]
subscription matching 2nd
     trigger events, determining
subscription matching costs (notification applications) 2nd
subscription objects
    creating
         for AddSubscriptions program 2nd
         with compound conditions 2nd 3rd 4th 5th
         with simple conditions 2nd 3rd
subscription quantum limits. [See also quantum limits]
subscription schedules
     restoring
subscription schemas 2nd
subscription selectivity. [See also scheduled subscriptions [NPN]]
subscription states
    music store application
         overview 2nd
subscription systems. [See also publish-subscribe models]
subscription throttles
     exceed throttles, troubleshooting 2nd
subscription throttles (deployment security) 2nd 3rd 4th
subscription view
     user-defined logic rule processing
SubscriptionClass class
     StockBrokerNMO
SubscriptionEnumeration class (Subscriber Management API)
SubscriptionEventRule class
     StockBrokerNMO
SubscriptionField class
     StockBrokerNMO
SubscriptionLoader tool 2nd 3rd
SubscriptionLoader. [See also NMO]
subscriptions
    adding
         in music store application 2nd
     as data 2nd
     definition of. 2nd [See also publish-subscribe models] [See also events]
    displaying
         in music store application 2nd
    enabling/disabling/removing
         in music store application 2nd 3rd 4th
     event and scheduled rules interaction 2nd
    event-triggered subscriptions
         adding 2nd
         declaring classes 2nd
         music store database 2nd 3rd
         overview 2nd
         schemas 2nd
     event-triggered subscriptions. [See also event triggered matching logic]
     granularity of 2nd
     management notification application phase 2nd
     quantum ordering 2nd 3rd
     quantum processing 2nd
     retrieving 2nd
    scheduled subscription class
         overview
         scheduled rules 2nd 3rd
         schema for subscriptions by genre 2nd
         subscription chronicles 2nd
         subscription states 2nd
    scheduled subscriptions
         music store application
         music store database 2nd 3rd
         testing 2nd 3rd
     scoping of data
     strict event batch ordering 2nd 3rd
     Subscriber Management APIs
    Subscriber Management APIs. [See Subscriber Management APIs]
    subscribers
         adding with T-SQL scripts 2nd
     times zones, troubleshooting 2nd
    troubleshooting
         no subscriptions to process 2nd
         non-matching subscriptions and events 2nd
subscriptions table
subscriptions view
     match rules
subscriptions. [See also state maintenance]
supllementary ADFs, utilizing
supplementary ADF
supplementary ADFs
     music store application
syntax checking
syntax errors
     in rules 2nd
syntax highlighting
sysadmin fixed server role
sysadmin fixed server roles
     development process
system configuration check
     installing SQL Server components