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.
| Author |
Topic |
|
sadat
Starting Member
1 Post |
 Posted - 2006-12-07 : 02:13:03
|
| Hello,I am having problems debugging a stored procedure using query analyzer of SQL server from a client machine. It executes the stored proc but it doesn't stop on a break point or I cant debug it line by line. Someone please tell me if there is a solution of this problem.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-07 : 02:47:19
|
| I don't think you can do that with Query Analyzer.If you call the SP withEXEC mySPthen the SP is run completely.You have to get the code for the SP and execute it statement by statement.Unless you are debugging it somewhere else, say... Visual Studio?Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-07 : 02:48:58
|
| Which version of SQL Server you are using? What are the service packs applied on SQL server? I think you need SP4 for debugging in QA.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Help! Line by line debugging with query analyzer