sql server replication: one publication or more ? -- sql server replication

one publication or more ?

Hassan
11/20/2003 9:40:34 PM

sql server replication: If i want to replicate all schema(tables,stored procs,views,indexed views
and functions) and data obviously , do i need to make one publication or
seperate for views and indexed views and functions as views need to depend
on tables being created and indexed views on views and functions on tables
or views...I hope you understand what im trying to get here. Using SQL 2000

one publication or more ?

Hilary Cotter
11/21/2003 5:02:39 AM

You should be able to use a single publication for this.
[quoted text, click to view]

RE: one publication or more ?

rboyd NO[at]SPAM onlinemicrosoft.com
11/21/2003 4:49:05 PM

Bear in mind that when you replicate stored procdures and views subsequent
changes to those procedures and views do not get replicate.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.