Ater table transactional replication

I have SQL Server 2000 transactional replication and it
works fine.
I need to break the replication to apply the vendor script
to the database. The vendor will modify database
objects.
I delete the transaction replication subscription.
I tried to alter a table and received an error stating
that the table could not be altered because it was
replicated.
What is the easiest procedure so that can apply the vendor
script.
Thanks,
Mark
Mark,
it depends on your particular modification, but in most cases you could use
sp_repladdcolumn and sp_repldropcolumn. Using these procedures there's no
need to drop the subscription. For more radical changes, you could also drop
the article from the publication and add it back in.
HTH,
Paul Ibison
|||And for your specific one, run sp_removedbreplication. If for some reason
it still gives you that error, turn on allow updates, update the replinfo
column in sysobjects and set it to 0, turn off allow updates.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||This seems a little drastic just to modify the schema. I think Paul's
response is more appropriate.
Rand
This posting is provided "as is" with no warranties and confers no rights.
sql