I am getting

Msg 8115, Level 16, State 1, Procedure sp_replmonitorrefreshagentdata,
Line 327
Arithmetic overflow error converting numeric to data type numeric.

Upon debugging the problem I came across
sys.fn_replgetpublicationthreshold. The reason why I am looking at
this is because it uses CAST on this function. I can not find it
ANYWHERE.

Ideas?

Erik

here it is:

create function sys.fn_replgetpublicationthreshold
(
@publication_id int,
@thresholdindex int
)
returns sql_variant
as
begin
declare @value sql_variant
select @value=value
from dbo.MSpublicationthresholds
where publication_id=@publication_id
and isenabled=1
and metric_id = @thresholdindex
return @value
end

I don't see a cast in it.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]