Prev: Log Shipping not restoring transaction log backup
Next: SQL Server 2000+2008 on Win2008x64 question
From: Toni on 31 Mar 2010 17:08
We are currently on SQL Server 2008 and I would like to add a column to a
table that exists in our merge replication.

Below is what I ran in our test environment
Alter Table TableName
Add ColumnNameTypeID uniqueidentifier Null

The column was added, but the Default value or Binding was set to NewID()
and the RowGuid property was set to Yes. I would like the Default value or
Binding not set to anything and the RowGuid set to No. Is there a way to
do this using the Alter Table command?

The new column added is a FK to another table. I am thinking after the
column is added and replicated to the subscriber, I will had the relationship
using SSMS.
Maybe I am going about this the wrong way?

Thanks in advance,
Toni



 | 
Pages: 1
Prev: Log Shipping not restoring transaction log backup
Next: SQL Server 2000+2008 on Win2008x64 question