January 10, 2019 at 4:01 pm
I am creating the following statistics on a memory-optimized table:
CREATE STATISTICS STATS_MyMemOptTable ON MyMemOptTable ( ID ) WITH FULLSCAN, NORECOMPUTE
When I run this in SSMS it works just fine. However, when I try adding it to Visual Studio it gives me error "SQL71569: Invalid syntax for a memory optimized object."
I need to create this stats in VS so it can be maintained through TFS. What am I doing wrong?
January 15, 2019 at 10:51 am
just a stupid guess, but what sql version do you have the VSTS Project set to?
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2019 at 10:56 am
VS 2015. But I tried on VS 2017 and still didn't work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply