July 27, 2004 at 11:04 am
I'm using DTS to transfer/copy a table from Server A to server B, both SQL 2000 w/sp3a.
Each time the job fails and returns the following error:
There is already an object named DF_tablename_field in the database
Could not create constraint
The field that it is failing on is tinyint with a default set to 0.
Any help woul be appreciated
July 27, 2004 at 12:04 pm
(1)Check in the New Database if that table got created,If yes delete it and try again as DTS might got failed in between.
(2)Try again Dts.
(3)If it fails again try use BCP to transfer that perticular table and transfer all other tables,view Etc using DTS
Mohammed
MCSA,MCDBA
July 28, 2004 at 5:49 am
Does the DTS package drop and recreate the table each time it runs?
To see if the constraint name is used by another object, run the following on server B:
DECLARE @cName sysname
SET @cName = '<name of your constraint>'
SELECT obj.id,
obj.type,
t.name AS tableName,
obj.name AS constraint_name
FROM sysobjects obj join sysobjects t ON obj.parent_obj = t.id
WHERE obj.name = @cName
July 29, 2004 at 2:44 pm
The DTS will not drop and recreate the table each time it runs. If the table is not there, it will create one. If the table is already there, it will copy data into it
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply