Error in Tranfer Objects and CHECK Constraint
-
I use a DTS to copy a database to another one on a differt server , both SQL2K sp3.
I get this message on destination log file:
::Error::
In file server.source.DR2 in statement on line 1408
Transfer Status: Creating DRI on destination database
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find CHECK constraint for 'dbo.table', although the table is flagged as having one.
I've already tried to rebuild by constraint but nothing changed.
The script coming from the source is correct and I can see the Constraint.
The destination database is created with the constrain.
So, it seems to be ok BUT the job FAIL.
Do someone know how can I work around this problem ?
Thanks for any help you can give me!
-
Have you tried dropping the check constriant and adding back.
-
Yes I have.
I dropped it from Enterprise Manager and then I added it from QA.
Nothing happend.
-
It would be helpful to know what is on line 1408. Does your DTS use Execute SQL Tasks? If so, check the stored procedures being called. Perhaps run them in Query Analyzer and find out what is on line 1408.
-
Absolutly yes... this is the script starting at line 1408.
/****** Object: Table [dbo].[tab] Script Date: 5/7/2004 2:07:41 AM ******/
ALTER TABLE [dbo].[tab] ADD
CONSTRAINT [PK_tab] PRIMARY KEY NONCLUSTERED
(
[fiield1],
[field2],
[field3]
 
WITH FILLFACTOR = 90,CONSTRAINT [CK_tab] CHECK NOT FOR REPLICATION ([field3] > 0)
GO
Executing it from QA it's workin fine. Infact, after Transfer Object, the new database has the constraint in it...
-
Am I understanding correct that this database has a table named "Table" and another table named "Tab" ?
-
Sorry... I replaced the table name one time with "Table" and one time with "Tab"...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply