You are currently offline, waiting for your internet to reconnect

FIX: Error message when you use the Transact-SQL LEFT or RIGHT function in a stored procedure in Visual Studio Team System 2008 Database Edition GDR: "An exception was thrown when the 'Maintain compatibility between data types.' rule was applied"

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 stored procedure that contains a LEFT Transact-SQL function to return the left side of a character string or a RIGHT Transact-SQL function to return the right side of a character string.
  • You click Run in the Static Code Analysis item of the Data menu.
In this scenario, you receive an error message in the Error List window:
An exception was thrown when the 'Maintain compatibility between data types.' rule was applied. The exception text is: ‘TSqlFragment is not the expected Microsoft.Data.Schema.ScriptDom.Sql.FunctionCall’.
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.
MORE INFORMATION
For more information about the LEFT function, visit the following Microsoft Web site: For more information about the RIGHT function, visit the following Microsoft Web site:
Properties

Article ID: 970566 - Last Review: 07/16/2009 08:03:46 - Revision: 1.0

Microsoft Visual Studio Team System 2008 Database Edition

  • kbprb kbexpertiseadvanced kbsurveynew kbqfe KB970566
Feedback
= 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" anguage);" class="ng-binding" id="language-es-py">Paraguay - Español
Venezuela - Español
://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>