MS Visual Studio error message while debugging a stored procedure

Asked By MarkDavis 0 points N/A Posted on - 07/20/2011

I have Microsoft Visual Studio 2010 Ultimate installed on Windows Server 2008 (x86 & x64) with Service Pack 2, 1GB RAM, 30GB of HD space, DirectX 9 capable video card running at 1024 x 768 .

While I was trying to debug a stored procedure, I got the following error message

There is no source code available for the current location

I tried logging in as a Sysadmin but it comes up with the same error. I tried performing `Allow SQL/CLR debugging` and restarted MS visual studio but the error persists. Could not find much in the web and this error is quite annoying ….

 Any suggestions?

• Status: Open
• Question Views: 1735
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By SPaul 0 points N/A #85514

MS Visual Studio error message while debugging a stored procedure

This error is caused due to a project that does not contain source code that you are trying to view or attempting to debug a dump file according to MSDN site.

The simplest solution of all is to:
1) Right click on the solution -> navigate to Common Properties -> ‘Debug Source Files’ tab ->then remove the entry and restart the MS visual studio again.
2) Also go to Tools ->Options ->Debugging ->General tab
3) Select the ‘Require source files to exactly match original version’ check box.
4) If possible, remove all the references and files including .pdb files and add them back.

You can access your code by selecting ‘Show Disassembly’ and ‘Step Into’ my code. After that right click the window and select ‘Go to Source Code’ to open up the coding. Visit https://msdn.microsoft.com/en-us/library/hdks6de6(VS.80).aspx for more details.

About SPaul

Questions
0

Answers
5

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/27/2011
• Question Category: MS SQL Server