Dec 21, 2013 by Dick Wenning Category: Uncategorized 0 comments

I

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144828’

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144827’

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PARTITION = 5637144829’

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.DATAPARTITION = “ps”‘

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.DATAPARTITION = “ext”‘

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.DATAPARTITION = “cube”‘

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PartitionKey = “ps”‘

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PartitionKey = “ext”‘

EXEC sp_MSforeachtable ‘SET QUOTED_IDENTIFIER ON; delete from ? where ?.PartitionKey = “cube”‘

delete PARTITIONS where recid = 5637144828

delete PARTITIONS where recid = 5637144827

delete PARTITIONS where recid = 5637144829

 

Leave a Comment!

Your email address will not be published. Required fields are marked *