Share via


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).

The CreateQueueReaderAgent method is available with SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.