When attempting to update to scenic 1.9.0 from 1.8.0 while using activerecord-sqlserver-adapter (8.0.8) we are unable to run db migrations.
bin/rails db:migrate
bin/rails aborted!
ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near 'current_schemas'. (ActiveRecord::StatementInvalid)
Caused by:
TinyTds::Error: Incorrect syntax near 'current_schemas'. (TinyTds::Error)
Logs to follow