Debugging Stored Proc

Hi,
When I go to debug any SP thru Object browser in query analyser ... it
starts well ... takes all the required parameters to begin ... but when I
click on execute button, it completes the SP execution immediately. It does
not allow to use functions like Step into, Step over etc ... Why does this
happen?
Because of this, my main purpose of debugging any SP, does not get satisfied
.
Pls Help."Krishnapra Paralikar" <Krishnapra
Paralikar@.discussions.microsoft.com> wrote in message
news:9DDB8999-67C1-44C8-ADD6-B2979892E612@.microsoft.com...

> When I go to debug any SP thru Object browser in query analyser
http://www.sql-server1.org/detail-7330883.html

debugger interface

Help,
I used to be able to debug a stored procedure in the query analyser.
But now I get an error indicating that I should re-run setup and add the
debugger interface.
the debugger is installed!!!!
if I take a look at the eventviewer I see following error
DCOM got error "the operation completed successfully" and was unable to
togon , \SQLdebugger in order to run the server.
What can I do to correct this problem and switch debugging on again?
Thanks,
MarcIt sounds like the DCOM permissions may no longer set
correctly. Check the topic in books online: Troubleshooting
the Transact-SQL Debugger
Make sure you follow all the steps, especially those for
DCOMCNFG.EXE
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Tue, 12 Apr 2005 09:40:48 +0200, "marc" <heev@.msn.com>
wrote:

>Help,
>I used to be able to debug a stored procedure in the query analyser.
>But now I get an error indicating that I should re-run setup and add the
>debugger interface.
>the debugger is installed!!!!
>if I take a look at the eventviewer I see following error
>DCOM got error "the operation completed successfully" and was unable to
>togon , \SQLdebugger in order to run the server.
>What can I do to correct this problem and switch debugging on again?
>Thanks,
>Marc
>

debugger interface

Help,
I used to be able to debug a stored procedure in the query analyser.
But now I get an error indicating that I should re-run setup and add the
debugger interface.
the debugger is installed!!!!
if I take a look at the eventviewer I see following error
DCOM got error "the operation completed successfully" and was unable to
togon , \SQLdebugger in order to run the server.
What can I do to correct this problem and switch debugging on again?
Thanks,
MarcIt sounds like the DCOM permissions may no longer set
correctly. Check the topic in books online: Troubleshooting
the Transact-SQL Debugger
Make sure you follow all the steps, especially those for
DCOMCNFG.EXE
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Tue, 12 Apr 2005 09:40:48 +0200, "marc" <heev@.msn.com>
wrote:
>Help,
>I used to be able to debug a stored procedure in the query analyser.
>But now I get an error indicating that I should re-run setup and add the
>debugger interface.
>the debugger is installed!!!!
>if I take a look at the eventviewer I see following error
>DCOM got error "the operation completed successfully" and was unable to
>togon , \SQLdebugger in order to run the server.
>What can I do to correct this problem and switch debugging on again?
>Thanks,
>Marc
>

debugger interface

Help,
I used to be able to debug a stored procedure in the query analyser.
But now I get an error indicating that I should re-run setup and add the
debugger interface.
the debugger is installed!!!!
if I take a look at the eventviewer I see following error
DCOM got error "the operation completed successfully" and was unable to
togon , \SQLdebugger in order to run the server.
What can I do to correct this problem and switch debugging on again?
Thanks,
MarcIt sounds like the DCOM permissions may no longer set
correctly. Check the topic in books online: Troubleshooting
the Transact-SQL Debugger
Make sure you follow all the steps, especially those for
DCOMCNFG.EXE
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Tue, 12 Apr 2005 09:40:48 +0200, "marc" <heev@.msn.com>
wrote:

>Help,
>I used to be able to debug a stored procedure in the query analyser.
>But now I get an error indicating that I should re-run setup and add the
>debugger interface.
>the debugger is installed!!!!
>if I take a look at the eventviewer I see following error
>DCOM got error "the operation completed successfully" and was unable to
>togon , \SQLdebugger in order to run the server.
>What can I do to correct this problem and switch debugging on again?
>Thanks,
>Marc
>

debugger interface

Help,
I used to be able to debug a stored procedure in the query analyser.
But now I get an error indicating that I should re-run setup and add the
debugger interface.
the debugger is installed!!!!
if I take a look at the eventviewer I see following error
DCOM got error "the operation completed successfully" and was unable to
togon , \SQLdebugger in order to run the server.
What can I do to correct this problem and switch debugging on again?
Thanks,
Marc
It sounds like the DCOM permissions may no longer set
correctly. Check the topic in books online: Troubleshooting
the Transact-SQL Debugger
Make sure you follow all the steps, especially those for
DCOMCNFG.EXE
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Tue, 12 Apr 2005 09:40:48 +0200, "marc" <heev@.msn.com>
wrote:

>Help,
>I used to be able to debug a stored procedure in the query analyser.
>But now I get an error indicating that I should re-run setup and add the
>debugger interface.
>the debugger is installed!!!!
>if I take a look at the eventviewer I see following error
>DCOM got error "the operation completed successfully" and was unable to
>togon , \SQLdebugger in order to run the server.
>What can I do to correct this problem and switch debugging on again?
>Thanks,
>Marc
>