Urgent Problem - Debug stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Giovanni pepe - 17 Dec 2004 13:57 GMT

I have this problems during the debug of a stored procedure:

1) In the immediate windows variabile are not set (these are nulls)
2) The step by step don't highilight the current line in yellow but
highlight some empty lines

I have SQL Server 2000
I have also deleted the stored and re-create, but this not solve the
problem
thank you

Reply to this Message

Steve Thompson - 17 Dec 2004 14:03 GMT

> I have this problems during the debug of a stored procedure:
>
[quoted text clipped - 5 lines]
> I have also deleted the stored and re-create, but this not solve the
> problem

Have you tried using SQL Profiler? I've found that utility to be extremely
valuable in debugging SP's.

Steve

Reply to this Message

cassius - 22 Jul 2005 06:56 GMT

Hi

IŽm from Brazil

IŽve been searshing all the web for the solution of this problem. W
may change some information about this

If you agree, reply this message. IŽll apreciate this..

One question: How big is your procedure? I heve one of 50k in tex
with this problem on debug

(Sorry about my english, itŽs not so well

Thanks

Reply to this Message