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

Debugg prev.

Hi ALL,
What is the minimal prev. required to debugg a stored procedure in SQL 2K.
Thanks
HariThere isn't anything specific that is required. In case of SQL Server
Service pack 3 this feature was disabled by default. Hence you need to
enable the same. Apart from that I dont see a pre-req you need to stare on.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ubAlNyB1DHA.2972@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hi ALL,
> What is the minimal prev. required to debugg a stored procedure in SQL 2K.
> Thanks
> Hari
>

---

|||Thanks Vinod.
The information I got regarding Debug prev. is,
1. The user should be in Master database
2. The same user should have Execute permission on system procedure
"sp_sdidebug" in master database.
Regards
Hari
MCDBA
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:uUaTF9E1DHA.1188@.TK2MSFTNGP11.phx.gbl...

quote:

---

> There isn't anything specific that is required. In case of SQL Server
> Service pack 3 this feature was disabled by default. Hence you need to
> enable the same. Apart from that I dont see a pre-req you need to stare

---

on.

quote:

---

> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:ubAlNyB1DHA.2972@.TK2MSFTNGP09.phx.gbl...
2K.[QUOTE]
>

---

Debug Stored Procedure

Hi All,
I wish to debug the stored procedure in SQL Server, but I am not
able to do so. Is there any sort of Configuration required on the
Server Side? When I try to debug the procedure it shows a warning that
"When SQL Service is started using Local Account debugging can not be
performed"
With warm regards
Jatinder SinghDid you have a look on "Troubleshooting the Transact-SQL Debugger" in the BO
L ?
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"jsfromynr" wrote:

> Hi All,
> I wish to debug the stored procedure in SQL Server, but I am not
> able to do so. Is there any sort of Configuration required on the
> Server Side? When I try to debug the procedure it shows a warning that
> "When SQL Service is started using Local Account debugging can not be
> performed"
> With warm regards
> Jatinder Singh
>|||Hi Jens
Thanks the problem was with
Incorrect DCOM permission settings
With warmr regards
Jatinder Singh