Drop a column

You just need to drop the default first:
ALTER TABLE dbo.ObjetName
DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
GO
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thank you very much Paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:1d5801c4fd6d$739195c0$a301280a@.phx.gbl...
> You just need to drop the default first:
> ALTER TABLE dbo.ObjetName
> DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
> GO
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Now I can drop the constraint and the column in the publicator.
I run the snapshot, but when I try start sincronizing, it's give me this
error
The schema script 'exec sp_repldropcolumn '[dbo].[TableName]', 'ColumnName',
1' could not be propagated to the subscriber. The step failed.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:1d5801c4fd6d$739195c0$a301280a@.phx.gbl...
> You just need to drop the default first:
> ALTER TABLE dbo.ObjetName
> DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
> GO
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||David,
you only need to run the snapshot agent if you're resynchronizing - and not
here. I suspect you have indexes/defaults on the subscriber that are
preventing the alter table working there. Now that the alter table is in the
queue, you'll have to remopve these constraints by hand before
synchronizing, or reinitialize. If you choose the former, it should be
obvious what is blocking the subscriber, but if not, have a look at logging:
http://support.microsoft.com/?id=312292
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)