June 23, 2010 at 1:44 am
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1073548784 description=Executing the query "IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_mytest]') AND type in (N'U')) DROP TABLE [dbo].[tbl_mytest] " failed with the following error: "Could not drop object 'dbo.tbl_mytest' because it is referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}"
June 23, 2010 at 3:56 am
You wont be able to drop the table whn there is a foreign key referncing it, you need to drop the reference or the referencing table first
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply