Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruchirj07
Starting Member
37 Posts |
 Posted - 2007-09-27 : 05:19:14
|
| Hi,I have a table used in Merge Replication. If i add a new column in that table it gives me an error for tables in which either this table is a key or this table has key from other tables "Error validating the default for column 'rowguid'." Also for views i'm getting an error "View 'dbo.vw_TestCaseBasic': indexes and schema binding will be removed."If i proceed further i get an error and m not able to add the column."It is invalid to drop the default constraint on the rowguid column that is used by merge replication.The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message.The transaction ended in the trigger. The batch has been aborted."Is there any solution for the same?Regards,Ruchir Jain |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-10-15 : 17:13:41
|
| You are trying to do many things here. Adding a column is straight forward in SQL2K5, what code you are using? Can you post it?------------------------I think, therefore I am - Rene Descartes |
 |
|
|
ruchirj07
Starting Member
37 Posts |
Posted - 2007-10-16 : 02:59:06
|
| There is no code as such, its a simple UI approach.I have a Db having SchemaBound views. The tables these views refer have primary and foreign keys and i'm using only tables for replication.The moment i add column from SSMS to the table i receive these errors.No special code, no special approach. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-06 : 15:14:05
|
These are error you will get even when not using replication.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-13 : 09:02:32
|
| How you got a rowguid on the pk? |
|
|
|
|
|
|
How to Add New Column in Table : Merge Replication