I've tried to get an answer out of TechNet on this ... they are very quiet.
Here is my problem:
My distribution database is growing because the distribution cleanup job is failing.
I have a separate distribution server - SQL 2005.
My Distribution cleanup job is failing with the following error:
Executed as user: \REPLDATA_BK\unc\LNGOKCSQLP003_BANKRUPTCY_BK-SMALLER TABLES A-C\20071203122870\'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015). The step failed.
However the error in the agent log says this:
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.
When I log in as the agent service account (also the account the job is running under) and exec the following:
exec xp_cmdshell 'dir d:\'
I don't have any problem.
Other people have seen this, but so far I've seen no resolution. I'm hoping you guys have some wisdom.