March 20, 2008 at 10:05 am
Ok, so I've never got this error before but yesterday I configured a Distributor to start testing replication and afterwards this error started to flood my SQL Agent error logs.
Not sure what is going on here.
Does anyone have an idea?
March 20, 2008 at 10:37 am
Which version of SQL Server? If it is 2005 then do you have SP2 installed?
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 20, 2008 at 12:00 pm
Yes, it is 2005, and no, I don't have service pack 2 installed. I take it I should do that?
March 20, 2008 at 12:14 pm
Its a bug in replication in 2005 and is fixed in SP2. Apply SP2 but you cannot revert back sp2 on 2005 server. So, test this on dev or testing server and apply.
link for sp2.
SQL DBA.
March 20, 2008 at 2:40 pm
yes. Please install SP2.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 20, 2008 at 2:53 pm
Alright, thanks, that seems to have fixed the problem. 🙂
January 7, 2009 at 8:00 am
Friends...
I already have installed SP2, I configured the replication, database mail and a job, and get the same error that SP2 supose to fix.
Please help me...
Paul
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply