Transactional Replication - Invalid object sysprocesses

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)

</dir>

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

</dir>
September 12th, 2015 8:53pm

Is this been occurring since configured or it occurred all of a sudden ?
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 12:59am

this occurs when SubscriptionStreams parameter is used. if I don't use more than one stream replication then replication latency goes high.
September 13th, 2015 6:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics