Re: Snapshot Repl. Failing with Foreign Key Constraints

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

HIlary,

Thanks for your reply!

I have carried out the actions you prescribed and have specified all tables
to keep the table unchanged. As this repl. includes stored proc. I am now
faced with the following:

3724: Cannot drop the procedure "sp name" because it is being used for
replication.

I have tried to specify that the stored procs are kept and receive the
following:

213: Insert Error: Column name or number of supplied values does not match
table definition

Any ideas?

Ian.



"Hilary Cotter" wrote:

> When you are specifying your articles, click on the browse button to the
> right of your table. In the snapshot tab, ensure that you are selecting the
> option keep existing table unchanged or delete all the data in the table
> options in the name conflicts portion.
>
> --
> 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
> "Urbankhaos" <Urbankhaos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7E669933-7446-4CD6-A866-209E8D6A03F1@xxxxxxxxxxxxxxxx
> > Hi Guys,
> >
> > I wondered if you would be able to assist on this one....?
> >
> > I have a server with several publications, all going to databases on one
> > subscriber at a remote site. Some of the DBs work fine with snapshot
> > replication and need no further attention. However, several of the DBs
> fail
> > out with the following error:
> >
> > 3726: Could not drop object "TBL NAME" because it is referenced by a
> foreign
> > key constraint.
> >
> > In the publication properties, articles tab, I have set the article
> defaults
> > for the tables NOT to Include declared referential integrity and have
> changed
> > the name conflicts to delete all data in the existing table. (I changed
> from
> > DROP the existing table and recreate it). When I do this I get the
> following:
> >
> > 4712: Cannot truncate table "TBL NAME" because it is being referenced by a
> > foreign key constraint.
> >
> > I have been chasing my tail on this for a while now and am gradually
> getting
> > dizzy in the process!!!!
> >
> > Any help you could offer would be very much appreciated....
> >
> > Cheers,
> >
> > Ian.
> >
> >
>
>
>
.

Relevant Pages

  • Re: ActiveX CAB Problems
    ... Hmm... ... it looks as if some of the articles I was thinking about ... specify that or even which version of Windows Update it is referring to ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Registry Key Replication Kills Performance
    ... some details regarding how registry replication works. ... Microsoft Cluster Server ... In order to get the services to work, I had to specify ...
    (microsoft.public.windows.server.clustering)
  • Re: specifying DC to use during a promo?
    ... To be able to specify a sourcing DC you need to use the advanced mode switch and use IFM ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... I ran it in my test environment but I didn't see a place where I could specify which DC to replicate from. ... I saw that I could pick either replication from a DC or from a file backup.. ...
    (microsoft.public.windows.server.active_directory)
  • RE: Having Problems using HOST_NAME
    ... I am implementing the solution using merge replication. ... > filters and join filters. ... > I want to use the HOST_NAME function to specify the login user by ... > the .hostname property is not passing in because I get no data replicated. ...
    (microsoft.public.sqlserver.replication)
  • Re: Bulk Insert Problem?
    ... must specify the individual column names since this table is part of an RDA ... replication. ... > when i want to update these rows from my remote server running on windows ...
    (microsoft.public.sqlserver.ce)