ReplicationDatabase.QueueReaderAgentExists Propiedad
Gets whether or not a Queue Reader Agent job exists for the database.
Espacio de nombres: Microsoft.SqlServer.Replication
Ensamblado: Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)
Sintaxis
'Declaración
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 de la propiedad
Tipo: System.Boolean
A Boolean value that indicates whether a Queue Reader Agent job has been created for the distribution database or not.
Excepciones
| Excepción | Condición |
|---|---|
| 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 Seguridad y protección (replicación). |
Comentarios
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).