December 14, 2015 at 2:29 am
Hi all I am trying to Archive the old data using sliding window partitioning. i was in need to switch the two partition to same table.
But, While trying i am getting error as below....
Msg 4905, Level 16, State 1, Line 1
ALTER TABLE SWITCH statement failed. The target table 'bank.dbo.tblFactsStaging' must be empty.
December 14, 2015 at 2:36 am
That's a very unambiguous message. What do you not understand about it? What statement are you running to get the error?
John
December 14, 2015 at 2:56 am
I was doing the partitioning the table.
I was only able to switch the partition to the table only when it was empty.
i was not able to switch the data when data is there meaning table is non empty.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply