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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-07-07 : 05:24:35
|
| Hi allwhen i try to drop a column.. i am getting the following error..Server: Msg 4932, Level 16, State 1, Line 1ALTER TABLE DROP COLUMN failed because 'CC_ADDRESS_VALIDATION_NUMBER' is currently replicated.could any one help on this..Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-07-07 : 05:30:57
|
| What's the problem? The message tells you what you need to know.-------Moo. :) |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-07-07 : 05:32:36
|
| Since i am new guy to DBA.. i am not able to follow it..Could u please elaborate the message i got...Thank u |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-07 : 05:38:09
|
| use sp_repldropcolumn instead of just dropping the columnfor syntax, go to BOLany tables engaged in replication and if you want to add more columns and tables are done via the replication sprocs--------------------keeping it simple... |
|
|
|
|
|
|
Unable to drop the column