OLDCHAPPY (6/9/2013)
Failed:(-1073548784) Executing the query "ALTER INDEX [ARFCRDATA~0] ON [bip].[ARFCRDATA] REO..." failed with the following error: "The index "ARFCRDATA~0" (partition 1) on table "ARFCRDATA" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
i'm trying to use a maintenance plan but i am hit with these errors. i'm sure there is a script that i can run to detect these guys so that i can skip them in the MP. or, as an option, turn ON page level locking for these tables, run the reindex/rebuild, then turn it back on.
try this... SELECT * FROM sys.indexes WHERE allow_page_locks = 0;
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.