Link to home
Start Free TrialLog in
Avatar of finance_teacher

asked on

Microsoft SQL Server 2014 -- debug table trigger ?

What is the best way to debug a Microsoft SQL Server 2014 table UPDATE trigger inside of Microsoft SQL Server 2014 Management Studio ? acts like maybe the below ?
 1. set a BREAKPOINT on insert into X(ID) values (1),(2)
 2. run insert into X(ID) values (1),(2) in DEBUG mode
 3. press F11 to "Step Into"
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

A simple way to debug a trigger would be to log certain messages into log tables or print some messages if you are trying to debug or test it from Query window..
There's no need to complicate much on this..
May I know what exactly you are trying to achieve so that we can guide you better.
Avatar of Mark Wills
Mark Wills
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial