Unanswered: "Invalid distribution command." how to overcome this (urgent help required))
"Invalid distribution command."
how to undo the command which is there in distribution database.
I tried to add 3 new columns on 1 of table in my publisher database.
may be due to some syntax error or some other reasons replication got stopped.
the error mssg i m getting is
Invalid distribution command.
last command is as follows.
if not exists (select * from syscolumns where name=N'Type'
and id = object_id('[Advertisement]')) begin if exists
(select * from sysobjects where name=N'syspublications')
if exists (select * from sysarticles where objid=object_id('[Advertisement]'))
not null ' else alter
table [Advertisement] add [Type] char(1)
not null else alter table [Advertisement]
add [Type] char(1)
Transaction sequence number and command ID of last execution
batch are 0x00066B35000000B5000200000000 and 1.
how to undo this command or what is the procedure to come out of this.
its very urgent pl any body come give some solutions.