felipesch
asked on
When I debug a simple procedure, the cursor dont stop in breakpoint!
I use a T-SQL Debugger, with a SQL server 2000, and I try to debug a simple procedure:
CREATE procedure DebugA
(
@IntIn int,
@IntOut int OUTPUT
)
as
Set @IntOut = @IntIn + 10
Return
GO
I insert breakpoints, but the cursor dont stop!
The sql-debugger only return "@RETURN_VALUE = 0"
Any idea?
Thanks.
CREATE procedure DebugA
(
@IntIn int,
@IntOut int OUTPUT
)
as
Set @IntOut = @IntIn + 10
Return
GO
I insert breakpoints, but the cursor dont stop!
The sql-debugger only return "@RETURN_VALUE = 0"
Any idea?
Thanks.
ASKER
No way....
Still dont stop...
Tks for help.
Still dont stop...
Tks for help.
are you aware, that @IntOut is not the same as @return_value ?
procedure can only return one integer return value. however, it can returns more parameters declared using OUTPUT keyword.
What happens, If you debug this SP in Query analyzer ?
procedure can only return one integer return value. however, it can returns more parameters declared using OUTPUT keyword.
What happens, If you debug this SP in Query analyzer ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EXEC sp_sdidebug 'legacy_on'