"Patrick Gibb" <PatrickGibb@discussions.microsoft.com> wrote in message
news:C9948AB8-9570-43C8-A94A-C30C80630762@microsoft.com...
> Hi
>
> I have script to manually create a publication and associated articles for
> transactional replication and, for various reasons, am using manually
> created
> views on my publisher and custom stored procedures on the subscribers for
> insert operations. The articles are added using @type = 'logbased
> manualview'.
>
> The script works fine and the resulting transactional replication works as
> expected. However when I view the properties of the publication and in
> particular the publication articles, using SQL Management Studio the
> information displayed does not match the infromation configured. For
> example,
> the INS, UPD and DEL statements are all listed as "Do not replicate...",
> whereas a call to sp_helparticle lists these properties correctly with
> "CALL
> MyInsertSP" etc.
>
> Problem seems to be with the @type of the article. If I add the articles
> using just @type = 'logbased', then SQL Management Studio displays them
> correctly.
>
> Am I missing something here...??
>
> Many thanks

"Hilary Cotter" wrote:

> Sounds like a UI bug, do the transactions replicate fine?
>
> --
> Hilary Cotter