SQL71501 errors when I try to build a project in SSDT

Question

SQL71501 errors when I try to build a project in SSDT

JeannieH(COLLABERA INC) 391

I am trying to Build a new project in SSDT. The only thing I did with this new project is create a simple 3 column table and I get these errrors when I try to build

SQL71501: Service: [ExternalMailService] has an unresolved reference to Queue [dbo].[ExternalMailQueue].  
SQL71501: Service: [InternalMailService] has an unresolved reference to Queue [dbo].[InternalMailQueue].	Udemy_cicd_20211025	  
SQL71501: Service: [syspolicy_event_listener] has an unresolved reference to Queue [dbo].[syspolicy_event_queue].

CathyJi-MSFT 22,406 Reputation points Microsoft External Staff

2021-10-27T07:16:25.37+00:00

Hi @JeannieH(COLLABERA INC) ,

Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
If it is not work, please let us know the progress.
JeannieH(COLLABERA INC) 391 Reputation points

2021-10-27T12:34:46.93+00:00

It actually generated more errors trying this solution. Since I got pulled onto another project, should I mark this as correct and log another question if I start the solution from scratch and get the same error when I try again?
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2021-10-27T21:23:55.763+00:00

It Cathy's answer did not help you, my opinion is that you should not mark it as an answer. That would not help people who run into the same problem.

1 answer

Your answer

CathyJi-MSFT 22,406 Reputation points Microsoft External Staff

2021-10-27T07:16:25.37+00:00

Hi @JeannieH(COLLABERA INC) ,

Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
If it is not work, please let us know the progress.
JeannieH(COLLABERA INC) 391 Reputation points

2021-10-27T12:34:46.93+00:00

It actually generated more errors trying this solution. Since I got pulled onto another project, should I mark this as correct and log another question if I start the solution from scratch and get the same error when I try again?
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2021-10-27T21:23:55.763+00:00

It Cathy's answer did not help you, my opinion is that you should not mark it as an answer. That would not help people who run into the same problem.

Answer 1

Hi @JeannieH(COLLABERA INC) ,

Add a database reference to master:
• Under the project, right-click References.
• Select Add database reference....
• Select System database.
• Ensure master is selected.
• Press OK.
Note that it might take a while for VS to update.

If it does not work, on the table sql file, please right click properties and verify the BuildSettings are set to Build.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

SQL71501 errors when I try to build a project in SSDT

1 answer

Your answer