Posted by Erland Sommarskog on 02/08/07 22:35

Jeff Kish (kishjjrjj@charter.net) writes:
> The debugger had been fairly nice to use when I had triggers and sp's
> to debug.
>
> I assume that it is a simple matter to invoke the procedure (I know
> how to compile it) to get things to run?

Not sure that I understand the question, just run it from Query Analyzer.

Triggers are a good point for the debugger. If you are not aware of that
there is a trigger, the debugger can make you aware, if you stick to F11.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: I don't understand this "server timeout"
• Prev in forum: Full date value not being written via JDBC - any ideas?
• Thread view: Re: any way to debug stored procedures without buying visual studio?

[Reply to this message]