ReplicationDatabase.CreateQueueReaderAgent Method

Article
12/03/2008

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

public void CreateQueueReaderAgent ()

public:
void CreateQueueReaderAgent ()

public void CreateQueueReaderAgent ()

public function CreateQueueReaderAgent ()

Exceptions

Exception type	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 Considerations for Replication.

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 Considerations for 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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via