create procedure sys.sp_MSgetarticlereinitvalue
(
@subscriber sysname,
@subscriberdb sysname,
@publication sysname,
@artid int,
@reinit int output
)
as
begin
set NOCOUNT ON
declare @retcode int
-- return NULL if no parameters supplied
if ((@subscriber IS NULL) or (@subscriberdb IS NULL) or (@publication is null) or (@artid IS NULL))
begin
select @reinit = NULL
return 1
end
-- PAL security check
exec @retcode = sys.sp_MSreplcheck_pull @publication = @publication
if @@error <> 0 or @retcode <> 0
begin
return (1)
end
-- get the value of reinit flag
select @reinit = queued_reinit
from syssubscriptions
where srvname = UPPER(@subscriber)
and (srvname is not null and len(srvname)> 0)
and artid = @artid
and dest_db = @subscriberdb
-- All done
return 0
end