I have transactional replication.
publisher - sql server 2008 r2 enterprise
distributor - sql server 2014 standard
subscriber - sql server 2008 R2 enterprise
Distribution Agent has below error message constantly for few hours and it stops.
I have to start distribution agent manually. I have found this on
https://support.microsoft.com/en-us/kb/934188 for SQL 2005. is this bug in SQL server 2008 R2.
Thanks.
Command attempted:
<dir>select spid, blocked, lastwaittype from sysprocesses where '~80~~84~~86~~87~~89~~90~~92~~95~' like '%~' + cast (spid as nvarchar)+ '~%' and '~80~~84~~86~~87~~89~~90~~92~~95~' like '%~' + cast (blocked as nvarchar)+ '~%'
(Transaction sequence number: 0x000745580000497C002400000000, Command ID: 5)
Error messages:
<dir>Invalid object name 'sysprocesses'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208
Invalid object name 'sysprocesses'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208