all groups > sql server replication > january 2006 >
You're in the

sql server replication

group:

editing a tables column part of snapshot replication problem


editing a tables column part of snapshot replication problem Sammy
1/20/2006 11:26:03 AM
sql server replication:
I have to edit a column in a table which is part of replication I have first
tried to drop the article first but get the following error. Does this sound
like a serious error in the system. I have also gone into EM and tried to
untick the table in the articles section of the publication but it does not
allow me to untick...am I doing something wrong. Thanks for any help

Sammy

exec sp_dropsubscription @publication = 'snapshot_details'

, @article = 'us_user'

, @subscriber = 'dataserver01'

, @destination_db = 'iusdss'

Server: Msg 208, Level 16, State 1, Procedure sp_dropsubscription, Line 145
RE: editing a tables column part of snapshot replication problem Sammy
1/20/2006 12:28:02 PM
Was running from distribution database and not subscription..now works thanks
Paul Ibison

[quoted text, click to view]
AddThis Social Bookmark Button