patternsqlMajor
Referencing system views in SSDT?
Viewed 0 times
referencingsystemviewsssdt
Problem
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
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
Solution
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.
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.
Context
StackExchange Database Administrators Q#40592, answer score: 26
Revisions (0)
No revisions yet.