mardi 23 décembre 2014

CodePlex: SQL Server Partition Management Tool


I have implemented partitioning on a table and now I want to use the CodePlex Partitioning Tool to create my staging/archive table, with the intentions of wrapping it all in a "Sliding Window" job.


When I run both createstagingnoindex or CreateStagingClusteredIndex - all works fine. However when I try to either apply indexes (indexstaging) or just use "CreateStagingFull" from the outset - I am getting the same error:


System.NullReferenceException: Object reference not set to an instance of an obj ect. at PartitionManagement.PartitionManager.createStgIndex(Index i, TableViewBase parent) at PartitionManagement.PartitionManager.createStgNonclusteredIndexes() at PartitionManagement.PartitionManager.CreateStgIndexes(Boolean createNonClu steredIndexes) at PartitionManagement.App.Run(AppArgs& parsedArgs) Object reference not set to an instance of an object.


Thanks in advance!


Keith.





Aucun commentaire:

Enregistrer un commentaire