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
>
Thursday, March 8, 2012
Cannot truncate table because it is being referenced by another ob
Labels:
configuring,
database,
error,
following,
ideasthanks,
microsoft,
mysql,
oracle,
recieve,
referenced,
replication,
resolve,
server,
servers,
sql,
table,
truncate
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment