February 24, 2007 at 3:47 am
hi,
i tried to execute sp_article filter but i got an error like this :
"Invalid object name 'syspublications'."
here is my code
DECLARE @publication AS sysname;
DECLARE @table1 AS sysname;
DECLARE @filter AS nvarchar(386);
DECLARE @filterClause as nvarchar(386);
SET @publication = N'InventaPubs';
SET @table1 = N'MasterLokasi';
SET @filter = N'filterLokasi';
SET @filterClause=N'KodeLokasi=220104000000';
EXEC sp_articlefilter
@publication = @publication,
@article = @table1,
@filter_clause = @filterClause,
@filter_name = @filter;
GO
any solutions?
and how can i change the filter clause the next time i need to change the article filter? do i just need to run the sp_articlefilter again and define another filter clause?
many thx...
February 25, 2007 at 11:48 pm
syspublications table is stored in the publication database...Make sure you are running in published db...
MohammedU
Microsoft SQL Server MVP
February 25, 2007 at 11:57 pm
i did run my stored proc. in published db but there is no syspublications in my published db...
iam pretty sure i've published my database, i can replicate my db to my smart device
any suggestion?
Aldrich
March 4, 2007 at 11:07 pm
up up..pls help me
Aldrich
March 8, 2007 at 9:44 am
anyone help me pls...
thx
Aldrich
March 10, 2007 at 8:56 pm
desperately need help here...pls
thx
March 10, 2007 at 10:30 pm
hmmm...my bad, i am using merge replication..thats why there is no syspublications table...
thx for helping
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply