Replication -- sql server clients

Linchi Shea
12/29/2003 12:07:33 PM

SQL Server has limited support for replicating DDL. You
can't simply make DDL changes to a table and expect them
to be replicated transparently. It has to be done through
special replicaiton stored procedures. See 'Schema Changes
on Publication Databases' in the BOL.

Linchi

[quoted text, click to view]

Noorali Issani
12/29/2003 3:27:37 PM

Can any body tell me that how can I replicate the DDL commands into
Subscriber ?

Waiting for your reply

Noor

Noorali Issani
12/30/2003 8:41:37 PM

No i didn't find any help on BOL regarding 'Schema Changes on Publication
Databases' could you please give me the detail data regarding this

[quoted text, click to view]

cgross NO[at]SPAM online.microsoft.com
1/2/2004 10:33:14 PM

Here's the MSDN link that is the equivalent of the SQL 2K BOL topic Linchi
pointed you to:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/rep
limpl_22pf.asp

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
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 about sql server clients

sql server clients : Replication