major difference between sp and trigger

hi
stored procedure and trigger which runs on serverside and which runs on client side.

---

Dear Kanthk,

Have a look at this :

http://www.sqlservercentral.com/columnists/gvijayakumar/storedprocedurevstriggers.asp

HTH,

Suprotim Agarwal