I'm confused, somehow I have version:
Version 1.9
Removed option for all database in simple recovery model
Listed out all 80 (or earlier) compatibility databases
15 Aug 2011
Yet, this is a December version of 1.4?
The reason I'm writing is, I have several databases that use row level locking. When I try the stored proc I get on some indexes: Number: 2552 [SQLSTATE 01000]
--*****Error: The index "PK__ICMUT013__6CFA4C671550F9CF" (partition 1) on table "ICMUT01331001" cannot be reorganized because page level locking is disabled. [SQLSTATE 01000]
--*****Object Name: [authjcrdb].[authjcrsch].[ICMUT01331001] [SQLSTATE 01000]
--*****Error Code: alter index [PK__ICMUT013__6CFA4C671550F9CF] on [authjcrdb].[authjcrsch].[ICMUT01331001] reorganize [SQLSTATE 01000]
I'm looking for the ability or changing to set to page level locking for the reindex and then go back to row level.