about transaction replication...

Hi everybody,
I am new to SQL replication , I use MS SQL 2000 with
SP3 . I use databases of a financial program which has 360 tables. But I
receive that error when replicating data :
Could not drop object 'dbo.TBLSUBELER' because it is referenced by a FOREIGN
KEY constraint.
(Source: UGUR (Data source); Error number: 3726)
Why this error occurs and what can i do ?
Best regards...
This error is caused because sysdepends is out of sync on your publisher.
All RDBMS's have this problem.
The best thing to do is to pre create your schema, save it to a script and
execute it as part of a pre snapshot command.
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
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
FOREIGN
> KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>
|||At what stage during the replication process are you getting this error?
This error is occurring because the specified table is being deleted, but
another table has a foreign key defined on it.
You can get this problem when re-applying the snapshot or running the agent
after the subscription has been reinitialised (which is also re-applying the
snapshot incidentally).
Raj Moloye
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
> FOREIGN KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>