In our current project we use Sql Server Data Tools (sqlproj) to put our database in source control. Recently we experienced random exceptions during loading and building the solution with multiple sql projects.
Last week our builds started to fail. The logging showed something like
MSB4018: The “SqlBuildTask” task failed unexpectedly.
Microsoft.Isam.Esent.Interop.EsentVersionStoreOutOfMemoryException: Version store out of memory (cleanup already attempted)
On Microsoft Connect we found a workaround. By adding commandline option /p:CmdLineInMemoryStorage=TRUE the build worked again. Seems there is someone working at Microsoft with a great name 😉
I can’t begin tell you how many times this blog post has saved me! Especially now that the Connect issue is gone. Thank you!