"Alfonso Larriva" <alarriva@yahoo.com> wrote in message
news:4jZ5g.34$AT.2889@news.uswest.net...
> Function sequence error
>
> (Source: ODBC Driver Manager (ODBC); Error number: 0)
>
>
>
>
>
> The process could not make a generation at the 'Subscriber'.
>
> (Source: Merge Replication Provider (Agent); Error number: -2147200994)
>
> ---------------------------------------------------------------------------------------------------------------
>
> Cannot insert the value NULL into column 'nicknames', table
> 'Softwise.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT
> fails.
>
> (Source: FC37 (Data source); Error number: 515)
>
> ----------------------------------------------------------------------------------
> ---
>
>
>
> ****
>
>
>
> I have a main SQL Server and I'm trying to setup another server that
> replicates to the first one. I copied the database across (because some
> items don't replicate), then I delete some of the tables so that I can
> replicate them across. And, somewhere in there I have to remove some
> triggers to get it to move forward. But, I'm stuck on this particular
> problem.
>
>
>
> I have seen lots of questions about this elsewhere, but I've not gotten a
> solution that works. I have checked the tables to make sure that the
> coallation is the same on both. I have added the ability to add nulls to
> the destination, but no luck there -- it doesn't work and it changes the
> table on the subscriber to be just like the publisher.
>
>
>
> Any suggestions what I can do to make this work? I'm using SQL Server
> 2000 SP 4 and the two machines are local. They both have names and are
> not using their own IP Addresses.
>
>
>
> The software company that wrote the software had their smart guy quit, and
> I'm smart, but I'm not exactly the SQL programmer. HELP HELP HELP.
>
>
>

"Alfonso Larriva" <alarriva@yahoo.com> wrote in message
news:4jZ5g.34$AT.2889@news.uswest.net...
> Function sequence error
>
> (Source: ODBC Driver Manager (ODBC); Error number: 0)
>
>
>
>
>
> The process could not make a generation at the 'Subscriber'.
>
> (Source: Merge Replication Provider (Agent); Error number: -2147200994)
>
> ---------------------------------------------------------------------------------------------------------------
>
> Cannot insert the value NULL into column 'nicknames', table
> 'Softwise.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT
> fails.
>
> (Source: FC37 (Data source); Error number: 515)
>
> ----------------------------------------------------------------------------------
> ---
>
>
>
> ****
>
>
>
> I have a main SQL Server and I'm trying to setup another server that
> replicates to the first one. I copied the database across (because some
> items don't replicate), then I delete some of the tables so that I can
> replicate them across. And, somewhere in there I have to remove some
> triggers to get it to move forward. But, I'm stuck on this particular
> problem.
>
>
>
> I have seen lots of questions about this elsewhere, but I've not gotten a
> solution that works. I have checked the tables to make sure that the
> coallation is the same on both. I have added the ability to add nulls to
> the destination, but no luck there -- it doesn't work and it changes the
> table on the subscriber to be just like the publisher.
>
>
>
> Any suggestions what I can do to make this work? I'm using SQL Server
> 2000 SP 4 and the two machines are local. They both have names and are
> not using their own IP Addresses.
>
>
>
> The software company that wrote the software had their smart guy quit, and
> I'm smart, but I'm not exactly the SQL programmer. HELP HELP HELP.
>
>
>

"Alfonso Larriva" wrote:

> I got through this problem by naming the server in Query Analyzer.
> Once FC37 had a name, this error went away.
>
> And, now I have new errors. Which I will post.
>
>
> "Alfonso Larriva" <alarriva@yahoo.com> wrote in message
> news:4jZ5g.34$AT.2889@news.uswest.net...
> > Function sequence error
> >
> > (Source: ODBC Driver Manager (ODBC); Error number: 0)
> >
> >
> >
> >
> >
> > The process could not make a generation at the 'Subscriber'.
> >
> > (Source: Merge Replication Provider (Agent); Error number: -2147200994)
> >
> > ---------------------------------------------------------------------------------------------------------------
> >
> > Cannot insert the value NULL into column 'nicknames', table
> > 'Softwise.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT
> > fails.
> >
> > (Source: FC37 (Data source); Error number: 515)
> >
> > ----------------------------------------------------------------------------------
> > ---
> >
> >
> >
> > ****
> >
> >
> >
> > I have a main SQL Server and I'm trying to setup another server that
> > replicates to the first one. I copied the database across (because some
> > items don't replicate), then I delete some of the tables so that I can
> > replicate them across. And, somewhere in there I have to remove some
> > triggers to get it to move forward. But, I'm stuck on this particular
> > problem.
> >
> >
> >
> > I have seen lots of questions about this elsewhere, but I've not gotten a
> > solution that works. I have checked the tables to make sure that the
> > coallation is the same on both. I have added the ability to add nulls to
> > the destination, but no luck there -- it doesn't work and it changes the
> > table on the subscriber to be just like the publisher.
> >
> >
> >
> > Any suggestions what I can do to make this work? I'm using SQL Server
> > 2000 SP 4 and the two machines are local. They both have names and are
> > not using their own IP Addresses.
> >
> >
> >
> > The software company that wrote the software had their smart guy quit, and
> > I'm smart, but I'm not exactly the SQL programmer. HELP HELP HELP.
> >
> >
> >
>
>