Method not found opening files in database project - by Chris Lively

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


11
0
Sign in
to vote
ID 653180 Comments
Status Closed Workarounds
Type Bug Repros 11
Opened 3/23/2011 3:23:22 PM
Access Restriction Public

Description

When attempting to open one of the sql files in a brand new database project, I received the following error:

Method not found:
'Microsoft.SqlServer.Management.SqlParser.Common.TransactSqlVersion
Microsoft.SqlServer.Management.SqlParser.Parser.ParseOptions.get_TransactSqlVersion()'.

Note that this worked just fine prior to installing SP1
Sign in to post a comment.
Posted by abatishchev on 6/1/2012 at 5:42 AM
Still getting this error. Attached a file as requested.
Posted by Vendoran on 4/28/2011 at 6:51 AM
Here's the problem that I saw.

Installing Visual Studio 2010 SP1 caused SSMS 2008 R2 Intellisense to die. Installing SQL 2008 R2 CU6 fixes SSMS Intellisense but killed Visual Studio's again. However SQL 2008 R2 CU7 fixes the problem again.
Posted by jcrawfor74 on 3/31/2011 at 2:56 AM
I suggest your issue is related to this problem.

https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1

Read the 6th post in the list:
"Posted by Dorel Adam on 17/03/2011 at 12:2" it explains the same error.

Issue occurs when:
1. Install VS2010 SP1 and you loose intellisense in SQL Server 2008 R2 SSMS.
2. Fix intellisense in SSMS by running Cumulative Update 6 for SQL Server 2008 R2
3. Now Intellisense is broken in Database projects in Visual Studio 2010, with the error you have described

I find it interesting that they have marked the other issue as fixed? It's not fixed on my machine, but I an yet to try out Dorel Adam's suggestion.


Posted by Chris Lively on 3/28/2011 at 1:34 PM
I have access to a second machine. It is also running Windows 7 x64 with visual studio 2010. The ONLY real software difference between the two is that the second machine does NOT have SQL Server 2008 R2 management studio installed. The one WITH the problem has 2008 R2. The one WITHOUT the problem has SQL Server 2008 with SP2
Posted by Microsoft on 3/25/2011 at 2:48 AM
Thank you for submitting feedback on Visual Studio 2010 and .NET Framework. Your issue has been routed to the appropriate VS development team for review. We will contact you if we require any additional information.
Posted by Chris Lively on 3/24/2011 at 8:24 AM
Files attached. Thanks
Posted by Microsoft on 3/24/2011 at 1:46 AM
Thank you for reporting this issue. Unfortunately, we are unable to reproduce the issue with the steps you provided.

Could you please provide us with an activity log? You can get it with the following steps:

1. Launch VS with /log (Type "devenv /log" into the start->searchbox)
2. Repro the bug.
3. Load to %APPDATA%\Roaming\Microsoft\VisualStudio\<version>\ and send us the file ActivityLog.xml.

It would be greatly appreciated if you could provide us this information as quickly as possible.

Thank you
Posted by Microsoft on 3/23/2011 at 4:15 PM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)