all groups > sql server replication > october 2005 >
You're in the

sql server replication

group:

Distribution Agent Error Number 306 with sp_AddDitEntryDsid...



Distribution Agent Error Number 306 with sp_AddDitEntryDsid... Charles Sun
10/5/2005 2:37:04 PM
sql server replication: I try to push my publishers to subscriber, there is a error number:306

The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
(Source: NTASH02 (Data source); Error number: 306)
the error appear after :
applied script sp_AddDitEntryDsird_345.sch, anyboday can help me?
charles Sun
RE: Distribution Agent Error Number 306 with sp_AddDitEntryDsid... Raymond Mak [MSFT]
10/6/2005 11:02:02 AM
Hi Charles,

sp_AddDitEntryDsird seems to be a procedure that you have published so you
may want to see if its definition contains illegal comparisons against
text\image column at the subscriber. In case you are wondering why the
procedure is perfectly legal at the publisher, it is possible the a column
referenced by the procedure had been changed to text\image after the
procedure was created or there is simply a schema mismatch between publisher
and the subscriber (certain non-text|image columns referenced by
sp_AddDitEntryDsird at the publisher somehow becames text|image columns at
the subscriber.) Which version of SQL Server are you running?

Hope that helps.

-Raymond

[quoted text, click to view]
AddThis Social Bookmark Button