sql71501 sql parameter has unresolved reference to build-in type Visual Studio 2012 DB project

Question

I am getting the following error with my database project in VS2012. The problem started when I added a custom type in my 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 the type in stored procedure which is also part of the database project

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

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

And build the database project I keep on getting the following error which is quite annoying since the stored procedure works flawlessly and there is no problem with the type.

SQL71501: Parameter: [dbo].[spupd_DestinationTripAdvisorData].[@Attractions] has an unresolved reference to Built-in Type [dbo].[DestAttractions]. Any pointers or help will be much appreciated.

Try rebuilding the project, or try again after closing VS and reopening it. I've seen this behavior before with custom types and never quite understood why it happens. — Keith
– Keith, Commented Feb 23, 2015 at 20:19
Also check the custom type's file properties in VS and make sure Build Action is set to Build. — Keith
– Keith, Commented Feb 23, 2015 at 20:20
Thanks Keith. That worked like a charm. Can't believe I missed the build action for the type's file properties. — user869375
– user869375, Commented Feb 24, 2015 at 5:17

csabee · Accepted Answer · 2017-06-20 12:43:30Z

12

In my case the solution was to change the Build Action of file what contains the type definition to Build.

answered Jun 20, 2017 at 12:43

csabee

1211 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql71501 sql parameter has unresolved reference to build-in type Visual Studio 2012 DB project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related