ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) not supported in sql azure


ALTER TABLE [tableName] SET (LOCK_ESCALATION = AUTO) is not detected as not supported by SQL Server.


ghuey wrote Mar 17, 2011 at 3:34 PM

Thanks for the info (I won't reply to all of them since the answer will be the same). Anyway, I will put some Regex rules in to catch the examples that you have provided me. Hopefully I will have them in v3.5.9. Also note, that you can add your own rules in NotSupportedByAzureFile.config (just so that you don't have to wait for me :-)).

Thanks again for your feedback!!!

wrote Feb 22, 2013 at 1:00 AM