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 |
|
bryan99y
Starting Member
42 Posts |
 Posted - 2003-06-11 : 16:03:41
|
| What is the process to make DDL changes on a subscriber database for SnapShot Replication? |
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-12 : 15:01:41
|
| trying to make a column data type change from decimal 18,0 to decimal 18,2 in snapshot replication.How does one do this? |
 |
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-13 : 09:32:08
|
| problems...alter table property alter column building_size_ext decimal(18,2)Server: Msg 4929, Level 16, State 1, Line 1Cannot alter the table 'property' because it is being published for replication.Warning: The table 'property' has been created but its maximum row size (14769) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. |
|
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-13 : 09:52:20
|
| will this work:(Snapshot Rep. - sql server 2000)1. exec sp_droparticle @publication = ...property table2. alter table property alter column building_size_ext decimal(18,2)3. exec sp_addarticle @publication = ...property tableif so, do I need to drop the subscriptions and add them after the above code is ran? |
|
|
|
|
|
|
DDL