Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Table Partition

Author  Topic  rosaxena Starting Member 1 Post Posted - 2008-10-14 : 20:51:42 Hi All, I am facing some problem in Partitioing the table and moving data from Partitioned Table... Well I have two tables. Table one has the Pk on 2 field. And table 2 is making foreign key from the first table. I created staging table. But did not created this Foreignkey relation in staging table. So While using switch from main tables to staging table i m geeting an error. ALTER TABLE SWITCH statement failed. SWITCH is not allowed because source table ABBeLog' contains primary key for constraint 'FK_ABC_CDE_log'. Please help... Thanks Rohit