| Author |
Topic |
|
samrat
Yak Posting Veteran
94 Posts |
 Posted - 2002-10-28 : 20:16:38
|
| Greetings,Just wanted to know what are the different ways of debugging stored procedures.Regards,Samrat |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-10-28 : 20:24:51
|
Begin a transaction and rollit back rather than committing. Fix any errors reported between the two. Probably considered a kludge of a method by some of the hoity-toity DBA/developers on the site though  .JustinHave you hugged your SQL Server today? |
 |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-10-28 : 21:04:00
|
| Thanx for the reply..I was looking more into the area of putting breakpoints and stepping through the code in Stored procedure. I am aware this is possible thru Visual Interdev, but not 100% sure abt the steps i need to go thru.Samrat |
|
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2002-10-28 : 23:20:34
|
| Hello,Thank you for your question.If you want to debug the store procedure pls write print statement whenever necessary................................."Heaven's light is our guide"Sanjeevshrestha |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-10-29 : 00:48:38
|
| Thanx that sounds like one way of doing it. I have found an article on microcoft website that goes through the steps in installing SQL debugging Tool, WHich gives me the ability to step through the stored procedure.attached is the link to the site of referencecheers,Samrat |
|
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2002-10-29 : 02:22:21
|
| use VS.NET..it has an AMAZING SQL debugger built in!..I was looking for that all my life!..U can step into stored procedures..put a break point wherever!..watch variables values..and everything U need!. |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-10-29 : 02:34:23
|
| You can debug a SP using Query analizer. Choose the SP in the treeview and then choose "debug" from the popup menu (rightclick). |
|
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2002-10-30 : 18:03:13
|
| Has anyone got that debugging tool in QA to work properly?? I've been playing with it for weeks and I don't know if I am doing something wrong, but I cannot step through the code and it seems to ignore all breakpoints I put in. Basically it just runs the proc as though I had pressed F5 - it's been driving me nuts!!!! |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-30 : 19:37:42
|
| I'm running SQL2k with latest service pack and it works fine. I have not tested remote debugging.Like rihardh says and to set a breakpoint I click in front the T-SQL statement where I want to stop and then you can use F11 to step through the sp. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-10-30 : 20:50:03
|
| I've not had any trouble debugging stored procedures. It works great for me. I can monitor variables and change their value and watch what else is called. I'm also on SQL Server 2000 with the latest service packs.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
Debuging Stored Procedure