Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avijit111@gmail.com
Yak Posting Veteran
55 Posts |
 Posted - 2009-08-19 : 08:32:02
|
| in the below mail procedure is their....what i got confused is how i will install that...when i will run below coding giving errors...asking for write procedures for all exec lines...first please u run once then u can understood...what i m actually saying....and if its need and table also.....actually i want to use that mail procedure on erp when trigger will fired then this send mail procedure generate mail to the given address.one dept_coda feild i m having in one table called dept_leav_summ..@udsid char(10),@screenid varchar(10),@company_no glcompany,@location_code gllocn,@lang_id tinyint,@mode tinyint,@key_value varchar(255),@emp_code varchar(6),@emp_name varchar(40),@leave_type varchar(10),@dept_code varchar(4)) when dept_code will fired the mail will generate....so please tell me that how could i write the procedure for all exec lines above in the send mail codeing above.... |
|
|
|
|
|
hi to all.......