Open
Description
- SqlPackage or DacFx Version: 162.6.15.1
- .NET Framework (Windows-only) or .NET Core:
- Environment (local platform and source/target platforms):
Steps to Reproduce:
-
Within a stored procedure, we have a script that specifies Forcescan index like below with multiple other joins. Eg:
<select * from sampletable with (forcescan, iNDEX (Pk_sampleindex)) where Id = 10> This index is not recognized during build. It works fine in DB which is in Compatibility level 160. SSDT property also shows 160. -
As soon as i add that Forcescan in code, it shows this error "SQL 80001 error: Forcescan is not a recognized table hints option....".
- Forceseek and other query hints are working fine.
Did this occur in prior versions? If not - which version(s) did it work in?
(DacFx/SqlPackage/SSMS/Azure Data Studio)