Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Database Options has an unresolved reference to Filegroup [FILESTREAM]

A previous iteration of a SQL Server Data Tools project in my Visual Studio solution utilized FileTables/FILESTREAM. The codebase has since been refactored to not use FileTables so I removed all files that referenced that feature. I'm now getting this error when I try to rebuild the project:

Error 367 SQL71501: Database Options has an unresolved reference to Filegroup [FILESTREAM]. Remove the reference using the project settings page of the project's properties.

Following the error message's instructions, I go into Project Properties > Project Settings > Database Settings and remove as many references to FILESTREAM as possible. I'm still getting this error message, however. How to I fix it?

Thanks in advance.

like image 521
im1dermike Avatar asked Nov 11 '15 19:11

im1dermike


1 Answers

A colleague informed me of the fix for this... If you are getting a build error for the database project, specifically an unresolved reference to the storage [FILESTREAM], close the solution or unload the offending database project, go into the project's folder and delete the file *.dbmdl.

like image 121
im1dermike Avatar answered Sep 28 '22 02:09

im1dermike