Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Beefy
Starting Member
21 Posts |
 Posted - 2001-12-11 : 12:42:48
|
| I found that you can breakpoint in sp's and managed to using the VB 6.0 debugging interface. But I cannot seem to breakpoint in triggers.The book says it is possible, but doesn't explain how. Has anyone managed to do it??The only other option is to call a sp from the trigger and do all the SQL and breakpointing in there.. At least for testing.. ;)Thanks...B..... Women may well be able to fake orgasms, but men can fake whole relationships ..... |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2001-12-16 : 06:32:28
|
quote:
I found that you can breakpoint in sp's and managed to using the VB 6.0 debugging interface. But I cannot seem to breakpoint in triggers.The book says it is possible, but doesn't explain how. Has anyone managed to do it??The only other option is to call a sp from the trigger and do all the SQL and breakpointing in there.. At least for testing.. ;)Thanks...B..... Women may well be able to fake orgasms, but men can fake whole relationships .....
You can give print statements on the trigger for testing. u can view that on query analyzer while Executing. |
 |
|
|
|
|
|
Breakpoints In T-SQL