trying to use PartitionTable with fast option

Apr 4, 2017 at 1:08 PM
We were trying to use your PartitionTable with fast option, but we get this error:

"the requirements for fast mode are not met",16,2

Looking in your code, this is what triggers the error:
           when @source_tab_id in (
                   select object_id from sys.indexes where data_space_id <> @in_fg)
                then 2
In our case, @in_fg = 6 and there are no indexes with that data_space_id in sys.indexes and as such, '2' is the result. But what is actually checked here?
Apr 5, 2017 at 9:49 AM
Hmm we tried running the PartitionTable command on an existing 200GB table, supplying partition scheme and compression with fastmode off, but all it did was erase the existing table including data and then create a partition table in its place. According to the log, it went through all the steps explained, but all data was lost during the operation. Fortunately this is a test server and we can restore a new database, but honestly, something is wrong with the script when it can lose all data. :-(