HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Where can I get the master.dacpac file for SQL Server 2012?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
canthefile2012sqlwheredacpacgetmasterfor

Problem

I am using Visual Studio 2012 Professional with SQL Server Data Tools with a SQL Server 2012 standard edition database instance.

I have been unable to locate a master.dacpac file on either my development machine or on the server hosting the SQL Server instance.

How can I obtain this file, so I can get rid of warnings like the following:

SQL71502: Procedure:  has an unresolved reference to object [sys].[objects]

Solution

You should be able to add a Database Reference. Click Project-> Add Database Reference. Click the radio button for System and then master. Code with references to objects in the master db should now build correctly.

Context

StackExchange Database Administrators Q#70091, answer score: 8

Revisions (0)

No revisions yet.