sysobject warnings in my DBPro projects

Problem

My DBPro project references sysobjects and is causing build warnings for example:

SQL04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].   

Solution

Add the following DB reference to your database project:

C:\Program Files (x86)\Microsoft Visual Studio 10.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\master.dbschema

If you are targeting 2005 SQL Server use:

C:\Program Files (x86)\Microsoft Visual Studio 10.0\VSTSDB\Extensions\SqlServer\2005\DBSchemas\master.dbschema

Comments are closed