title: how to create before update trigger in sql server 2005
body: <p>Is there anyway where I can create a trigger which will execute before the update/delete takes place( and then the actual update/delete takes place)? and how can I <code>drop</code> a trigger from a table?</p>