Error on Snapshot Apply

I'm setting up trasactional replication and am encountering an error I've
never seen before...
On certain articles I receive a "CANNOT USE EMPTY OBJECT OR COLUMN NAMES"
error.
What exactly is that? I've been looking through the groups and can't seem to
fins anything on this.
Any help would be greatly appreciated.
Thank You!
I've never seen it either, can you post your schema and publication creation
scripts here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:B9416619-67DA-4F25-9259-6E637F447213@.microsoft.com...
> I'm setting up trasactional replication and am encountering an error I've
> never seen before...
> On certain articles I receive a "CANNOT USE EMPTY OBJECT OR COLUMN NAMES"
> error.
> What exactly is that? I've been looking through the groups and can't seem
to
> fins anything on this.
> Any help would be greatly appreciated.
> Thank You!
|||Sorry Hilary:
I ended up recreating the subscription and lost the old scripts. The
snapshot is applying as we speak so we'll see if it occurs again.
I do have one question, however. The client that I'm at right now tends to
implement quite a few database changes and quite often. I've told them that
the only two ways to properly apply these changes is to either do it through
the gui or utilize the system stored procedures.
They are wondering if there's a prettier way to address this, either through
a tool or for the subscriber to somehow "pick up" on changes made at the
publisher. They've tossed the idea aound of applying ALTER table statements
at both publisher and subscriber and that should be good enough. I've told
them that's not gonna cut it.
I guess I'm just looking for confirmation that there is no "easy" way around
this issue...
Thanks!!
"Hilary Cotter" wrote:

> I've never seen it either, can you post your schema and publication creation
> scripts here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:B9416619-67DA-4F25-9259-6E637F447213@.microsoft.com...
> to
>
>