Home All Groups Group Topic Archive Search About

How to debug SQL Stored Procedure on 2005

Author
21 Dec 2005 9:50 PM
Shimon Sim
I can't debug SQL Stored Procedure on SQL Server 2005.
I don't see any options in Management Studio and in VS.NET 2005 I see
options but it is disabled.
What should I do?
Thank you,
Shimon

Author
21 Dec 2005 10:56 PM
Hugo Kornelis
On Wed, 21 Dec 2005 16:50:37 -0500, Shimon Sim wrote:

>I can't debug SQL Stored Procedure on SQL Server 2005.
>I don't see any options in Management Studio and in VS.NET 2005 I see
>options but it is disabled.
>What should I do?
>Thank you,
>Shimon
>

Hi Shimon,

The debugging feature has been removed from SQL Server. The support is
still there, but you have to use Visual Studio 2005 Pro or Team Suite to
use it.

I entered a suggestion on the Microsoft's Product Feedback Center to
bring back the debugging feature in SQL Server. If you feel that this is
important, then let Microsoft know by voting for it. Here's a link
(warning - may wrap due to length)

http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackId=FDBK41174

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
Author
22 Dec 2005 12:29 AM
Shimon Sim
Thank you. (I voted.)


Show quote
"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:r8njq1t07ul5h771a6jl6hlroc514jtfv8@4ax.com...
> On Wed, 21 Dec 2005 16:50:37 -0500, Shimon Sim wrote:
>
>>I can't debug SQL Stored Procedure on SQL Server 2005.
>>I don't see any options in Management Studio and in VS.NET 2005 I see
>>options but it is disabled.
>>What should I do?
>>Thank you,
>>Shimon
>>
>
> Hi Shimon,
>
> The debugging feature has been removed from SQL Server. The support is
> still there, but you have to use Visual Studio 2005 Pro or Team Suite to
> use it.
>
> I entered a suggestion on the Microsoft's Product Feedback Center to
> bring back the debugging feature in SQL Server. If you feel that this is
> important, then let Microsoft know by voting for it. Here's a link
> (warning - may wrap due to length)
>
> http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackId=FDBK41174
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
Author
22 Dec 2005 10:31 AM
Alastair
Voted as well =)

AddThis Social Bookmark Button