SQL Server 2005 Debugging Tools?

[gcoast]

Does anyone know of any 3rd party debugging tools for SQL Server 2005? I know that Visual Studio 2005(Pro) will do the job but we don't use VS and it costs too much to justify purchasing multiple copies for debugging SQL stored procedures.

Regards,

GCoast

 

[sunila7]

Have you tried SQL Server Management Studio from microsoft? Another tool that I have tried is

http://www.sqlmanager.net/en/products/mssql/manager.

There is Lite Edition which is a free tool and works really well.

Sunil

 

[gcoast]

SQL Server Management Studio doesn't support debugging. Microsoft's solution is to purchase their Visual Studio 2005 Professional software. Have you actually used the debugger in the SqlManager Lite product?

 

[gcoast]

anybody else have a suggestion?

 

[oradba101]

Hi, gcoast

How about Toad? There is a free version available at

http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm

Regards,


William Chadbourne
Oracle DBA

 

[gcoast]

William, thanks for the TOAD info. I downloaded the free version and it's pretty amazing how much their giving away free. Unfortunately, the debugger is not available on the freeware version and the full version cost $595.

Anyone else have any ideas.

Thanks,

gcoast

 

[philhege]

What have you used in the past to debug T-SQL? Do you really need to step through a procedure to debug it? I've been "debugging" SPs in QA for years; no big deal.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[gcoast]

Phil, in the past we've used QA to step through sp's and it's worked ok. But that was with SS2000 and as we plan to migrate to SS2005 there is no QA option.

We have some pretty long sp's and inserting print statements just doesn't cut it. We need to keep our present ability of stepping through the code. I know that MS Visual Studio(Professional) has that capability but we don't have plans to use VS2005 Pro and I am trying to find a low/no cost method of debugging sp's in SS2005.

Thanks,

gcoast

 

[ptheriault]

SQL 2000 QA will work with SQL Server 2005.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gcoast]

ptheriault, well I have been connecting to the SS2005 server via QA and querying data but when I try to debug a sp using QA I get the message,
"[SQL-DMO] You must use SQL Server 2005 management tools to connect to this server."

Have you actually used the debugger in QA to step through a SS2005 sp? If so, I must have a configuration issue.

Thanks,

gcoast

 

[ptheriault]

No haven't tried to use the debug option for a 2005 db. If I have to debug something I'll just add print statements.
Have you checked the new version of Aqua Data Studio. I beleive that has debugging.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gcoast]

Thanks for the feedback ptheriault, I will look into your suggestion.

Has anyone actually used any software other than MS Visual Studio 2005 (Pro or Team) to debug a stored procedure in SS2005?

Thanks,

gcoast

 

[gcoast]

I checked with Aqua Data Studio and they don't have a debugger either(plan on having one in a future release).

Any other ideas?

Thanks,

gcoast