SQL Debugging in VS2005 Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

accyboy1981 - 12 Jul 2006 11:52 GMT

Hi,

I'm trying to debug an SQL 2005 store procedure within Visual Studio
2005. I open the store procedure via the server explorer and place the
break points where I want them. I then select 'Step Into Store
Procedure' it loads the debugger and asks for the parameters. However
all the breakpoints are then greyed out and when hovered over it says:

'The breakpoint will not currently be hit. Unable to bind SQL
breakpoint at this time. Object containing the breakpoint not loaded.'

Then when I try to step through the store procedure the debugger exits.
Is there anything else that needs to be done to debug a store
procedure?

Any help would be much appreciated.

Thanks

Simon

Reply to this Message

Tim Macaulay[MSFT] - 12 Jul 2006 15:36 GMT

Simon,

I found this Microsoft Knowledge Base Article that sounds like your issue.
It appears that if you rename the SQL Server, and the SQL Server Name and
the Computer Name are different, then it will not step into the debugger.

I hope this helps!

817253 Cannot debug a stored procedure in Visual Studio 2005 or in Visual
Studio .NET after you rename SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;817253

Cheers,
Tim Macaulay, MCSD, MCSD.NET, MCAD, MCP
Microsoft Developer Support ADSI
This posting is "AS IS" with no warranties, and confers no rights.

http://mact312.sts.winisp.net/programming/default.aspx

ADSI Start Page:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/a
ctive_directory_service_interfaces_adsi.asp

System.DirectoryServices Portal
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dsportal/ds
portal/directory_services_portal.asp

Reply to this Message

accyboy1981 - 12 Jul 2006 17:12 GMT

Hi,

Both the computer name and the server name have not changed and are the
same. I've still tried this without much success.

Simon

> Simon,
>
[quoted text clipped - 22 lines]
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dsportal/ds
> portal/directory_services_portal.asp

Reply to this Message

SQL Debugging in VS2005 Problems

Free Magazines