I have a Distribution clean up job failing on a SQL 2K5 Enterprise Instance (Windows Server 2003) Failing with the following error:-
Executed as user: *******. Could not remove directory 'DIRECTORY....'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015). The step failed.
I have checked all the obvious xp_cmdshell permissions, account permissions etc.
I can delete the folders when I log on to the server as admin.
When i look in to event viewer i find this error:-
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.