sql server replication: Hello All Friends !

If any body wants to delete All Merge Replication Tables,I have the solution
Pls write to me At -vinbisht@yahoo.com

Can any body tell me how to delete Rowguid column which gets generate in table After Replication whether Replication Sucess or fails, and I want to know differenece between Start Agent and Start Synchronize.

Bye..
Vineet Bisht

Hello Vineet Bisht -
Rowguid column is essential for the replication to work. If
you have enabled your replication, then SQL server will not allow you to
delete this column since the actual merge happens based on the data in this
column. However if you have disabled the publication thereby removing the
replication setup, then you should be able to drop the column. The column
has a constraint which needs to be dropped first. Once the constraint is
dropped, you can drop the column with the simple ALTER TABLE statement.

Regards,
Chandra

--------------------
||Thread-Topic: Replication Problem
||thread-index: AcPgLJp5Xk3M1wCQQcSck2rvk7Robw==
||X-Tomcat-NG: microsoft.public.sqlserver.replication
||From: =?Utf-8?B?dmluZWV0IGJpc2h0?= <vinbisht@yahoo.com>
||Subject: Replication Problem
||Date: Wed, 21 Jan 2004 06:41:07 -0800
||Lines: 10
||Message-ID: <688E53BF-02AB-4F4C-AC20-F1996CF3E798@microsoft.com>
||MIME-Version: 1.0
||Content-Type: text/plain;
|| charset="Utf-8"
||Content-Transfer-Encoding: 7bit
||X-Newsreader: Microsoft CDO for Windows 2000
||Content-Class: urn:content-classes:message
||Importance: normal
||Priority: normal
||X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
||Newsgroups: microsoft.public.sqlserver.replication
||Path: cpmsftngxa07.phx.gbl
||Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.replication:46653
||NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
||X-Tomcat-NG: microsoft.public.sqlserver.replication
||
||Hello All Friends !

If any body wants to delete All Merge Replication Tables,I have the
solution
Pls write to me At -vinbisht@yahoo.com

Can any body tell me how to delete Rowguid column which gets generate in
table After Replication whether Replication Sucess or fails, and I want to
know differenece between Start Agent and Start Synchronize.

Bye..
Vineet Bisht

||