Showing posts with label referenced. Show all posts
Showing posts with label referenced. Show all posts

Thursday, March 8, 2012

Cannot truncate table because it is being referenced by another ob

I recieve the following error after configuring replication between two servers. I am not sure how to resolve it. Does anyone have any ideas?
Thanks in advance,
Peter
Cannot TRUNCATE TABLE 'TwAccType' because it is being referenced by object 'TwAccTypeUserNotNull'.
(Source: TUMIME2 (Data source); Error number: 3729)
Event Type:Information
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:203
Date:6/15/2004
Time:10:42:06 AM
User:N/A
Computer:TUMIME1
Description:
SubSystem Message - Job 'TUMIME1-IME-TUMIME2-2' (0x73197FC085876B4BB39379788ECBA652), step 2 - Cannot TRUNCATE TABLE 'TwAccType' because it is being referenced by object 'TwAccTypeUserNotNull'.
Thanks Paul-
I will get back to you.
"Paul Ibison" wrote:

> Truncate Table can't be done if the table has FKs
> depending on it. If you look on the article properties,
> snapshot tab there is a naming conflicts section. Is yours
> set to 'Delete all data in existing table?'. If so then
> this is the cause of your error. You could drop the
> constraint in a pre-script and add it back if nesessary in
> a postscript. These options are available on the
> Publication Properties, Snapshot Tab.
> HTH,
> Paul Ibison
>