ReplicationDatabase.CreateQueueReaderAgent Method
Creates a Queue Reader Agent job for the distribution database.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Sub CreateQueueReaderAgent
'Usage
Dim instance As ReplicationDatabase
instance.CreateQueueReaderAgent()
public void CreateQueueReaderAgent()
public:
void CreateQueueReaderAgent()
member CreateQueueReaderAgent : unit -> unit
public function CreateQueueReaderAgent()
Exceptions
Exception | Condition |
---|---|
ApplicationException | When the Queue Reader Agent job already exists for the distribution database. When the distribution 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 Security and Protection (Replication). |
Remarks
The CreateQueueReaderAgent method can be called by members of the sysadmin fixed server role.
Calling CreateQueueReaderAgent is equivalent to executing sp_addqreader_agent (Transact-SQL).