October 20, 2008 at 8:28 am
Hi,
i am trying to create a merage replication, i don't know where i m doing mistake, what i did, i totally taken the copy of Server A and restore on Server B, each and everything is same, but still dont know y the following error is comming up..
The schema for the article [dbo].[fn_QUERYING_Get_Text] was either not generated properly or was not applied properly during initial synchronization. This may be due to permissions issues. Verify whether the object exists, and whether the necessary permissions are granted.
there is not much in the funtion . its a table valued funtion.. plz find blow the code of the funtion as well..
the function is working fine i hv run this ..but still dont know where i m makeing mistake
ALTER FUNCTION[dbo].[fn_QUERYING_Get_Text]
(
@QueryID int,
@SearchString VarChar(8000)
)
RETURNS @DocIDs TABLE (DocID bigint)
AS
BEGIN
DECLARE @BatchID int
SET @BatchID = (SELECT ISNULL(BatchID,0) FROM Qs WHERE QID = @QID)
SET @SearchString =REPLACE(@SearchString,'"','')
IF @BatchID = 0
BEGIN
INSERT INTO @DocIDs SELECT Ct.DocID
FROM Ct INNER JOIN CONTAINSTABLE(Ct,t,@SearchString) FT_TB
ON Ct.AID = FT_TB.
INNER JOIN Ds ON Ct.DocID = Ds.DocID
WHERE Ds.Dd = 0
END
ELSE
BEGIN
INSERT INTO @DocIDs SELECT Ct.DocID
FROM Ct INNER JOIN CONTAINSTABLE(Ct,At,@SearchString) FT_TB
ON Ct.AID = FT_TB.
INNER JOIN Des ON Ct.DocID = Des.DocID
INNER JOIN Ds ON Ct.DocID = Ds.DocID
WHERE Des.BatchID = @BatchID
AND Ds.Dd = 0
END
RETURN
END
October 22, 2008 at 9:08 am
Surely you don't need to apply the snapshot if you already have a copy of the publisher? Just uncheck the Initialize checkbox. Or am I misunderstanding you?
Matt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply