Sunday, December 16, 2012

Self Note: Get Replication status


The following script is to find the error within recent 30 min.


use distribution;
go
select
case
when COUNT(*)>0 then 'there are error for replication during the last half hour'
else 'no error found'
end
from msrepl_errors
where [time] > DATEADD(MINUTE, -30, GETDATE())
go

No comments: