I ran the snapshot agent several times.

The article was generated but it did not make it to the subscriber.

All of the other articles that I added since then did not...

I added Articles to be published but they did not make it to the subscriber.

Is there a way to force the articles to be applied?

I have added 100 + articles to what is going to be the production Server.

Should I do an image of that Server and apply it to the test Server?

Thank you Gail. 🙂

I added a view article and I missed one table referenced in the view.

I added over 100 articles but I missed one table.

When I ran the snapshot agent it bombed...

Thanks for the input.

My concern is that is I add a bunch of articles and I break replication and have to regenerate a new snapshot bec ause I missed a...

The problem is that if I add the view as an article and I miss a table referenced in the view. The snapshot agent bombs out and I'm forced to...

That is not going to work.

Thanks.

That only returns tables.

I'm...

Actually I'm looking for the objects (Views & Functions) not the Columns.

Thanks.

I can copy and paste but not the whole line when I try and scroll.

Could you please place the code outside of the CQL Code Tag?

Thanks.:-)

drew.allen (7/13/2015)

---

ISNULL() requires an opening paren and the subquery also requires an opening paren. You are trying to conflate them. You also have the second argument of the ISNULL() in...

The following does not work:

SELECT Name

FROM sys.Objects

WHERE is_replicated = 1

AND type_desc IN ('VIEW')

ORDER BY Name

??

I'm not getting the syntax right.:blush: