SQLTeam.com | Weblogs | Forums

Distribution Cleanup Issue


#1

My Distribution DB is keep on growing and the Distribution clean job fails with the below error.

I have added the login XYZ in the Administrators group of windows and provided sysadmin permissions to it even then the job fails with the same message.

Executed as user:XYZ. You do not have sufficient permission to run this command. Contact your system administrator. [SQLSTATE 42000] (Error 14260) Replication-@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables. [SQLSTATE 01000] (Message 14152). The step failed.