Debugging SQL Server 2000 using Query Analyzer

I'm trying to debug some procedural functions in SQL Server 2000 using Query Analyzer, and not having much luck.

Any help would be appreciated!

Thanks,

Doug

I have seen people trying to do that but I think it does not exist but SQL Server tells you were the error is, and can show you execution cost, but if you have a problem stored proc check out the profiler at the top of the Query Analyzer. Hope this helps.|||

I just wrote a quick Stored Proc and called the function from that..

it stepped through the function fine..

dd

|||

That would mean all the issues list below by Microsoft are fixed.

http://support.microsoft.com/default.aspx?scid=kb;en-us;280101