Este tema aún no ha recibido ninguna valoración - Valorar este tema

SubscriptionConditionEventRule Properties

SQL Server 2005

(see also Protected Properties )
  Nombre Description
ms219001.pubproperty(es-es,SQL.90).gif ActionTimeout
Gets or sets the interval during which the Transact-SQL statements specified in the SqlExpression property must complete successfully.
ms219001.pubproperty(es-es,SQL.90).gif EventClassName
Gets or sets the name of the EventClass associated with the SubscriptionConditionEventRule.
ms219001.pubproperty(es-es,SQL.90).gif InputTypeName
Gets or sets the name of the view or table that contains input data for the SubscriptionConditionEventRule.
ms219001.pubproperty(es-es,SQL.90).gif InputTypeSchema
Gets or sets the database schema name for the table or view specified by the InputTypeName property.
ms219001.pubproperty(es-es,SQL.90).gif Name 
Gets or sets the name of the object.
(inherited from NamedSmoObject )
ms219001.pubproperty(es-es,SQL.90).gif Parent
Gets or sets the parent SubscriptionClass object for the SubscriptionConditionEventRule.
ms219001.pubproperty(es-es,SQL.90).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms219001.pubproperty(es-es,SQL.90).gif SqlExpression
Gets or sets the Transact-SQL query used to generate notifications from the input and subscription data.
ms219001.pubproperty(es-es,SQL.90).gif 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.
ms219001.pubproperty(es-es,SQL.90).gif SqlUserName
Gets or sets the name of the database user Notification Services creates to run the statements specified in the SqlExpression property.
ms219001.pubproperty(es-es,SQL.90).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms219001.pubproperty(es-es,SQL.90).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms219001.pubproperty(es-es,SQL.90).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )
  Nombre Description
ms219001.protproperty(es-es,SQL.90).gif ExecuteForScalar 
Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
(inherited from SqlSmoObject )
ms219001.protproperty(es-es,SQL.90).gif 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 )
ms219001.protproperty(es-es,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms219001.protproperty(es-es,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )
¿Te ha resultado útil?
(Caracteres restantes: 1500)

Adiciones de comunidad

AGREGAR
© 2013 Microsoft. Reservados todos los derechos.