MS Visual Studio error message while debugging a stored procedure

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #85514

MS Visual Studio error message while debugging a stored procedure

qa-featured

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 http://msdn.microsoft.com/en-us/library/hdks6de6(VS.80).aspx for more details.

Login/Register to Answer

Related Questions