title: Trigger vs. stored Procedure
body: <p>I have a stored procedure that updates a flag in a table and a trigger that deletes the row updated and insert it in a new table. So the same functionality of the trigger can be added in the stored procedure. So I just wanna know:</p>
  
  <p>Which is better to use: stored procedure or trigger? And in what cases? In other words, can you give me the advantages and disadvantages of each one?</p>
  
  <p>Note that I'm using SQL server 2008 and I'm connecting VB.NET to my database.</p>