3

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: <ProcedureName> has an unresolved reference to object [sys].[objects]
Philᵀᴹ
  • 31,952
  • 10
  • 86
  • 108
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54

2 Answers2

8

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.

brian
  • 1,053
  • 6
  • 7
0

The master.dacpac and msdb.dacpac files for SQL 2012 are usually installed at C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\100\SQLSchemas\

mustaccio
  • 28,207
  • 24
  • 60
  • 76
StingyJack
  • 101
  • 4