What is the cleanest way to setup Replication Publication such that
only table schema is published and no data. I cannot see a property
for this under Article Properties for tables. Do I have to setup a row
filter to return no rows?
Thank you.

This kind of goes against the sense of replication :) Why not just script
out the schema and apply the script at the subscriber computer? It avoids
the creation of agents and the unnecessary use of filters.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Setting up a row filter is one option. You can also use a pre or post
snapshot command to send it down in a publication which only contains schema
only objects (like stored procedures, views, and functions).

If you deployed your subscribers via a unc you can use sp_addscriptexec to
run a script on all subscribers.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

If you are using SQL2005 (distributor), there is an unofficial /NoBcpData
switch supported by the snapshot agent. But then again, that is an
unofficial switch that comes with no warranty whatsoever :)

-Raymond

[quoted text, click to view]