0

Partition Scheme

Hi,

I have a large FACT-tables in my DWH (copy from a view in stage). I have tried to add partitions. I didn't help that much, so I removed it again.
But since I removed it, the table can't be deployed. I get the below error. I can re-add the partition, but still the same error:

An error occurred during drop partition function. See exception details for the failing object
An error occurred during drop user defined function. See exception details for the failing object: Drop failed for PartitionFunction 'FactSalesOrder_History_PartitionFunction'.
An exception occurred while executing a Transact-SQL statement or batch.
Partition function 'FactSalesOrder_History_PartitionFunction' is being used by one or more partition schemes.

Details:

SQL Server: '.'
SQL Procedure: ''
SQL Line Number: 2
SQL Error Number: 7706

I'm not sure how to find and drop what-ever TX is complaining about.
Tried this:
DROP PARTITION FUNCTION FactSalesOrder_History_PartitionFunction

and then get this:
Partition function 'FactSalesOrder_History_PartitionFunction' is being used by one or more partition schemes.

Any suggestions on how to proceed?

3 comments

Please sign in to leave a comment.