Referencing system views in SSDT? I've imported a database into SSDT containing a reference to a system view (specifically, sys.columns). The problem is, that I then get warnings about unresolved references when I build the project

From what I've seen on MSDN forums, it looks like it may be a known issue: http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/5a7026bd-0602-42e6-a639-d73bed903c26

Now, I know I can switch the warning off or ignore it, but does anyone know of an actual solution?

Thanks
This should be handled by adding a reference to the master database.



Previously, we've had issues related to the relative path that's used to reference the master.dacpac (as described here). If I remember correctly, we pulled a copy of the master.dacpac file into the local project and referenced it using the last option shown in the dialog above. This is not ideal however as you'll need to remember to update your copy of the reference periodically.

Will update if I can find the details of what was causing a problem with the referencing method.