I'm relatively new to SQL server and am having a couple of (what could be simple) problems with TRIGGERS against tables in the database.
I have successfully got INSERT and DELETE Triggers set up against the table but have been unable to set one up for the UPDATE action - can someone post a simple example that I can build on ?
Also - is there a way to disable and then re-enable TRIGGERS again (setting them to active/inactive) ? I can't see anything at first glance that would allow me to do this - am I missing the obvious ?
Thanks in advance,
Steve
I have successfully got INSERT and DELETE Triggers set up against the table but have been unable to set one up for the UPDATE action - can someone post a simple example that I can build on ?
Also - is there a way to disable and then re-enable TRIGGERS again (setting them to active/inactive) ? I can't see anything at first glance that would allow me to do this - am I missing the obvious ?
Thanks in advance,
Steve