Proprietà ReplicationDatabase.QueueReaderAgentExists
Gets whether or not a Queue Reader Agent job exists for the database.
Spazio dei nomi Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Sintassi
'Dichiarazione
Public ReadOnly Property QueueReaderAgentExists As Boolean
Get
'Utilizzo
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
Valore proprietà
Tipo: System.Boolean
A Boolean value that indicates whether a Queue Reader Agent job has been created for the distribution database or not.
Eccezioni
| Eccezione | Condizione |
|---|---|
| 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 Sicurezza e protezione (replica). |
Osservazioni
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).