Propriedade do RDL ReplicationDatabase.QueueReaderAgentExists
Gets whether or not a Queue Reader Agent job exists for the database.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (em Microsoft.SqlServer.Rmo.dll)
Sintaxe
'Declaração
Public ReadOnly Property QueueReaderAgentExists As Boolean
Get
'Uso
Dim instance As ReplicationDatabase
Dim value As Boolean
value = instance.QueueReaderAgentExists
public bool QueueReaderAgentExists { get; }
public:
property bool QueueReaderAgentExists {
bool get ();
}
member QueueReaderAgentExists : bool
function get QueueReaderAgentExists () : boolean
Valor da propriedade
Tipo: System.Boolean
A Boolean value that indicates whether a Queue Reader Agent job has been created for the distribution database or not.
Exceções
Exceção | Condição |
---|---|
ApplicationException | When the database does not exist. When the Queue Reader Agent has not been upgraded to the Microsoft SQL Server 2005 replication agent security model. For more information, see Segurança e proteção (Replicação). |
Comentários
The QueueReaderAgentExists property can only be retrieved by members of the sysadmin fixed server role and members of the db_owner fixed database role.
Retrieving QueueReaderAgentExists is equivalent to executing sp_helpqreader_agent (Transact-SQL).