Firstly let me say what an awsome website this is - ive got a project that i need to complete and this site has helped heaps.
My project involves building an application with a vb.net front end and an sql server 2000 backend. My problem is that i have created triggers on my table in server 2000 and I was wondering how I would know if they had been triggered when I did something like an insert via VB.net.
Would i have been better off creating each trigger as a store procedure and then calling them one at a time before i modifyed data?
Would your answer work equally well for different types of triggers (instead of,for,after)
Thanks for your help - my aplogies if this has already been answered (im stressing out)