Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 keeping breakpoint and debugging

Author  Topic 

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-02-27 : 04:39:32
hi, is there any possiblity to keep break point and run the step by step compilation as like we do in .net,if means please telll me how to do?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-27 : 05:57:21
If you are using SQL 2000, it is certainly possible from QA. Just select the Procedure you want to debug, right-click and select Debug.

You need to install SQL Server SP4.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2007-02-27 : 06:16:16
hi harsh_athalye ,yes i am using sqlserver2000. where can i get the sp4.please can u give step through the process to debug please
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-27 : 06:19:25
You can download it from microsoft site:

[url]http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -