| Author |
Topic |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2002-09-09 : 08:18:47
|
| Hi everybody, Is there any utility for executing Transact-SQL in step-by-step mode, in SQL Server 7.0 ? Is it there for SQL Server 2000 ? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-09 : 08:40:45
|
| Yes there is.If you put everything in stored procs then you can test them separately and sholdn't have a need for it.I think for v7 it was distributed with visual studio.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2002-09-09 : 10:07:43
|
| Yes..Visual Studio.NET has a WONDERFUL SQL debugger within it!..Step BY Step execution, variables watchs and everything! |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2002-09-09 : 10:12:17
|
| Visual Studio 6 Enterprise Edition also contains a T-SQL debugger |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-09 : 10:45:59
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19636 |
|
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-09-09 : 10:53:12
|
| What is the tool name? I have v6 enterprise, and don't seem to have it!Thanks |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2002-09-09 : 10:54:51
|
| If you have it, the tool can be found under Add-Ins/Add-In Manager/ VB T-SQL DebuggerHope this helps.Edited by - ehorn on 09/09/2002 10:55:28 |
|
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-09-10 : 02:18:15
|
| Thanks to all! Ehorn, I found Visual Studio's T-SQL debugger and I can see the stored procedure's code on loading it. But when I press F5 (execute) or F8 (step), the error message "The query could not be debugged due to a problem coordinating events with the server. Check the server and client log to find the exact cause, fix the problem and try again." shows up. In the applications event log it says "Cannot load the DLL SDI, or one of the DLLs it references. Reason:126 (The specified module could not be found).". Please help. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-10 : 09:17:34
|
| It's possible that some of the add-ins/components were not installed when you installed Visual Studio. Get the CDs and run setup again, there's an option to add components only. |
|
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-09-11 : 08:29:35
|
| Thanks Robvolk!The missing file SDI.DLL was found in the SQL Server 7.0 CD. I copied it to the MSSQL7\Binn folder and registered it, which fixed the problem. Now the debugger is running absolutely fine. |
|
|
|
|
Transact-SQL debugger?