FIX: Error message when you add a stored procedure that references a method in a managed assembly in Microsoft Visual Studio Team System 2008 Database Edition GDR: "<Schema>.<Stored Procedure> has an unresolved reference to Assembly <Assembly Name>"

Article translations Article translations
Article ID: 970577 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • You create a Microsoft SQL Server database project by using Microsoft Visual Studio Team System 2008 Database Edition GDR.
  • You add a reference to a managed assembly.
  • Then, you add a stored procedure that references a method of a class in the managed assembly of the project.
In this scenario, you receive an error message that resembles the following on the Error List window:
TSD03006: Procedure: [Schema].[Stored Procedure] has an unresolved reference to Assembly [Assembly Name].

CAUSE

This problem occurs because a System.IndexOutOfRangeException exception is thrown when the assembly metadata is processed.

RESOLUTION

To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
970479 List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2

Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 970577 - Last Review: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbexpertiseadvanced kbprb kbsurveynew kbqfe KB970577

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com