1

I've made an ASP.NET MVC 4 project in Visual Studio 2012 and I haven't made any modifications to it. When I run it and click on login, it generates the tables for the default database. So far so good... However, when I try to view these, I get the following error:

Failed to retrieve data for this request. An exception occurred while executing a Transact-SQL statement or batch. Invalid column name 'is_memory_optimized'.

Does anyone have any ideas why a template project does not work?

RickL
  • 3,318
  • 10
  • 38
  • 39
Esch
  • 79
  • 1
  • 5
  • Did you play around with the SQL Server 2014 CTP? `is_memory_optimized` is a new feature. – usr Oct 14 '13 at 09:19
  • I did, but not much. I removed the 2014 version and installed 2012 version instead. Maybe there's something to reinstall in VS.. – Esch Oct 14 '13 at 10:16
  • Looks like you got wrong SMO versions somewhere. Look at all vesions of Microsoft.SqlServer.Smo.dll on your disk and make sure they are at most of version 11. Version 12 should be SQL14, poisoning your machine. Maybe it is easiest to reinstall VS. – usr Oct 14 '13 at 10:20
  • Checked the install locations and the highest version I have is 11. I'll see if a reinstall helps, even if it's annoying to do so. – Esch Oct 14 '13 at 10:32
  • Reinstalled VS and tested with a new project, still no luck :/ – Esch Oct 14 '13 at 13:14
  • Time for blunt measures: install WinGrep and search the entire drive C: for the case-sensitive string "is_memory_optimized". Include binary files (up to 100MB). I suspect that this will show you a location that you did not yet check. – usr Oct 14 '13 at 14:05
  • Unfortunately, the program tends to freeze searching medium to large folders >_< I guess I'll try to work my way around this inconvenience. EDIT: I just found that I can view my databases in SQL Server Object Explorer view. No clue why Server Explorer view is still not working, but using the other view at least makes it possible to see the data and schemas, so it's at least a workaround. – Esch Oct 14 '13 at 15:03
  • You can limit the max file size in the tool. You can also try limiting to *.dll because that will tell you which product is using SQL14 features. You could also look into the programs and features applet to see if something is left there. – usr Oct 14 '13 at 15:55

0 Answers0