query debugger?

I'm setting up a learning environment at home so that I can learn to program
stored procedures. I need a debugger so that I can set breakpoints, examine
variable values, etc.
Is there any way to get the SQL Server 2000 query debugger to work with
MSDE?
If not, would it be worthwhile to get the SQL Server 2000 developer edition
for $50?
T.I.A. for you suggestions.
hi Scott,
Scottww wrote:
> I'm setting up a learning environment at home so that I can learn to
> program stored procedures. I need a debugger so that I can set
> breakpoints, examine variable values, etc.
> Is there any way to get the SQL Server 2000 query debugger to work
> with MSDE?
> If not, would it be worthwhile to get the SQL Server 2000 developer
> edition for $50?
> T.I.A. for you suggestions.
long time ago a free debugger was available by Quest Software, SQL
Navigator, free but time bombed... now I'm no more able to find it on theyr
site... my best advice is SQL Server Dev edition ($50) which provides you
all the tools you ever need for SQL Server development, including Profiler
and Index Tuning...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply