SubscriptionConditionEventRule Properties
SQL Server 2005
(see also
Protected
Properties
)
| Nombre | Description | |
|---|---|---|
| ActionTimeout |
Gets or sets the interval during which the Transact-SQL statements specified in the SqlExpression property must complete successfully.
|
| EventClassName |
Gets or sets the name of the EventClass associated with the SubscriptionConditionEventRule.
|
| InputTypeName |
Gets or sets the name of the view or table that contains input data for the SubscriptionConditionEventRule.
|
| InputTypeSchema |
Gets or sets the database schema name for the table or view specified by the InputTypeName property.
|
| Name |
Gets or sets the name of the object.
(inherited from
NamedSmoObject
)
|
| Parent |
Gets or sets the parent SubscriptionClass object for the SubscriptionConditionEventRule.
|
| Properties |
Gets a collection of Property objects that represent the object properties.
(inherited from
SqlSmoObject
)
|
| SqlExpression |
Gets or sets the Transact-SQL query used to generate notifications from the input and subscription data.
|
| SqlLoginName |
Gets or sets the Microsoft SQL Server login account that Notification Services uses to create the database user that runs the statements specified in the SqlExpression property.
|
| SqlUserName |
Gets or sets the name of the database user Notification Services creates to run the statements specified in the SqlExpression property.
|
| State |
Gets the state of the referenced object.
(inherited from
SmoObjectBase
)
|
| Urn |
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from
SqlSmoObject
)
|
| UserData |
Gets or sets user-defined data associated with the referenced object.
(inherited from
SmoObjectBase
)
|
| Nombre | Description | |
|---|---|---|
| ExecuteForScalar |
Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
(inherited from
SqlSmoObject
)
|
| ObjectInSpace |
Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly.
(inherited from
SqlSmoObject
)
|
| PresetProperties |
Gets or sets the preset properties of the referenced object.
(inherited from
SqlSmoObject
)
|
| ScalarResult |
Gets the scalar result for the referenced object.
(inherited from
SqlSmoObject
)
|