This topic has not yet been rated - Rate this topic

MSSQL_ENG020596

SQL Server 2005

Product Name	SQL Server
Product Version	9.0
Product Build Number	9.00.1399.60
Event ID	20596
Event Source	MSSQLSERVER
Component	SQL Server Database Engine
Symbolic Name
Message Text	Only '%s' or members of db_owner can drop the anonymous agent.

Explanation

You do not have sufficient permissions to drop the agent for the anonymous subscription. The login used when calling sp_dropanonymousagent (Transact-SQL) must be a member of the sysadmin fixed server role at the Distributor or db_owner fixed database role in the distribution database, or the user must be the one that initiated the first run of the agent.

User Action

Concepts

Cause and Resolution of Replication Errors

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD