Geek Answers Handbook

Sql71501 sql parameter has an unresolved reference to the Visual Studio 2012 DB built-in project type

I am getting the following error with my database project in VS2012. The problem started when I added a custom type to the database project in VS2012.

CREATE TYPE [dbo].[DestAttractions] AS TABLE(
[TAAttractionId] [varchar](10) NOT NULL,
[TARatingImgUrl] [varchar](256) NULL,
[TAReviewCount] [int] NULL,
[TAReviewUrl] [varchar](256) NULL)

When I try to reference a type of stored procedure that is also part of a database project

CREATE PROCEDURE [dbo].[spupd_DestinationTripAdvisorData]
@DestinationId INT,
@TAAwardImgUrl VARCHAR(256),
@Attractions dbo.DestAttractions READONLY
AS
BEGIN

------
------
END

And create a database project, I keep getting the following error, which is very annoying as the stored procedure works flawlessly and there is no type problem.

SQL71501: Parameter: [dbo]. [spupd_DestinationTripAdvisorData]. [@ Sights] has an unresolved link to the built-in type [dbo]. [DestAttractions]. Any pointers or help would be greatly appreciated.

+4
1

Build Action , Build.

+3

More articles:


All Articles