RE: SP and Trigger debugging
From: Ramnadh (Ramnadh_at_discussions.microsoft.com)
Date: 09/17/04
- Next message: Boknaai: "RE: Linked Server -> Distributed query"
- Previous message: fdde: "Reformatting a RecordSet"
- In reply to: Just D.: "SP and Trigger debugging"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Sep 2004 01:35:02 -0700
It is more feasible if you debug the stored procedures and Triggers from the
SQL Server. If any way you need IDE to debug the stored Procedure VS.Net
provides the facility to debug the Procedure and Triggers with an excellent
IDE. You can try with it.
"Just D." wrote:
> All,
>
> How are you doing debugging of this stuff? If I wrote a SP or Trigger in a
> few thousand lines including variables, loops. switches, error code
> evaluation, etc., it's hard or even impossible to use the Query Analyzer to
> look inside the working process like from a usual programming environment.
> Maybe I don't know anything, but I really would like to get some IDE where I
> can go through the script step by step, look into variables, fields, etc.,
> stop execution any time, interrupt, restart, etc. If something like that
> exists in the world? Is it possible to get it for reasonable money or for
> free as a component of a MSSQL Server, VS 2003, or whatever?
>
> Thanks,
> Just D.
>
>
>
- Next message: Boknaai: "RE: Linked Server -> Distributed query"
- Previous message: fdde: "Reformatting a RecordSet"
- In reply to: Just D.: "SP and Trigger debugging"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
