T-SQL Debugger

[Toyman]

Hi
I'am using the T-SQL Debugger to debug stored procedures executed from VB. But as soon as I get an error, I can't get back into debug mode. The only way to do this is to reboot the server (Hard-boot). Stopping and starting SQL Server only works with Win 98. But our server is running Win2k.

Does anybody had the same problem and know how to fix it ???
Thanks
Toyman

 

[aalmeida]

I had a Lot of problems debuggin sql stored procedures from VStudio 6 sp3, I don't know if sp4 would fix those issues, what we actually did was we purchase a t-sql programers package, our evaluation criteria was:
1) T-Sql writing and debuggin;
2) Visual Source Safe integration and Version Control, in this issue a nice to have was added, the flexibility of implementing change control policy;
3) Allow windows authentication to the SQL server during debuggin and programing.
We found that
- Quest SQL Navigator it has a good interface for programing, it has some VSS functionality that help to generate base lines bringing code from SQL server into VSS but check in and check out are not fully implemented, and it requires a server side installation, you can find a free dowload at

http://www.quest.com

.
- BMC SQL Programer if the porpouse was jus debugging the BMC sw is easier to set up and do not use MS DLL for debuggin what gives you a more relible connection to the SQL servers when you're steping into, and it the easyest to set up since it is the only one that did not require server side set up, but it has some issues with VSS that makes the vertion control not relible and check in and out feature do not really works, , you can find a free dowload at

http://www.bmc.com

- Rapid SQL from Embarcadero it seems to have a good aproach but has also the issue of using the MS dll's to run sql debuggin and we know that is not reliable even for V Studio, it has though an exelent interface with VSS allowing a strong version control as well as it supports the creation os a Build to update the servers that also provides enviroment isolation(Dev, QA, Prod) but it has a big draw back the set up require server side configuration but as well as NT server reboot, , you can find a free dowload at

http://www.embarcadero.com

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"