Debugging a stored procedure from Visual Studio

Question

I have Visual Studio 2010 and I just upgraded to SQL Server 2012. 

I want to debug a stored procedure from managed code. I add the server under Data Connections in Visual Studio, and then when I want to expand the procedure, I get this message:

"The server version is not supported. Only servers up to Microsoft SQL Server 2008 are supported."

Does anybody know of what it's and how to work around it?

Thank you.

---

Evgueni Tsygankov

Answer 1

Sounds like you are hitting a compatibility issue with SQL 2012

In past VS 2005 had issue connecting to SQL 2008 and it got fixed in one of the service packs.

Report this to Microsoft at http://connect.microsoft.com/sqlserver

Answer 2

Don't know if this helps, but...

http://blogs.msdn.com/b/ssdt/archive/2011/11/30/ctp4-installation-issue-with-vs2010-service-pack-1.aspx

RLF

Answer 3

I already have SP1 installed, so it must be a compatibility issue.

---

Evgueni Tsygankov

Answer 4

SSDT is released with the release of SQL Server 2012, even though it can also manage earlier versions SQL Server.

I understand that SP1 is installed, but just wanted to make sure you saw this line:

"Manually reapplying this pack will perform the necessary actions to repair this problem."

That may not be your problem, but you could try manually reapplying VS 2010 SP1.

All the best,
RLF

Answer 5

check this tutorial, You will get an idea

http://www.dotnetspark.com/kb/3799-steps-to-debug-stored-procedure-sql-server.aspx