Accelerated Database Recovery - Incorrect Syntax Error
I was recently working with some of the new features of SQL 2016 and 2019, found that a combination of two was causing me a lot of headaches. Not sure if you have come across this scenario but:
While working with an Always Encrypted connection and to enable yourself to see the data you have to turn on one of the advanced setting in your connection by using - "Column Encryption Setting=Enabled".
While this setting is used in your connection to a specific database, you will not be able to ALTER DATABASE to SET a setting like ACCELERATEDDATABASERECOVERY to ON or OFF. It will throw the following error: 'Incorrect syntax near ACCELERATEDDATABASERECOVERY'.
I can SET COMPATIBILITY_LEVEL but, I haven't tried any other setting. It took me so long to figure out why I was getting this error because the error thrown by SQL Server was just not enough to let me know what the issue is.