Hello Gurus,
i have a very strange problem that is killing me..

I have a stored procedure that e-mails, that stored procedure is called from
diffrent table triggers..

on table a the trigers fires and e-mail.. everything is ok..

on table b the triger fires and e-mail is sent however in IIS it's comes up
under the mailroot\Drop and never gets deliver.

can someone please help me troubleshoot.

let me know if you need more info.. what you want me to clarify.

thank you in advance

"Henok Girma" <reply@in.newsgroup.only.com> wrote in message
news:GGGxc.72$FC3.55@bignews1.bellsouth.net...
> Hello Gurus,
> i have a very strange problem that is killing me..
>
> I have a stored procedure that e-mails, that stored procedure is called
from
> diffrent table triggers..
>
> on table a the trigers fires and e-mail.. everything is ok..
>
> on table b the triger fires and e-mail is sent however in IIS it's comes
up
> under the mailroot\Drop and never gets deliver.
>
> can someone please help me troubleshoot.
>
> let me know if you need more info.. what you want me to clarify.
>
> thank you in advance
>
>

Which versions of MSSQL/Outlook/Exchange do you have? Is the trigger code
exactly the same on both tables? Are you using SQL Mail or an external mail
tool? Can you post the piece of trigger code which sends the mail?

Simon

thank you, it all of a sundden started working!!!
the triggers are exactly the same, except a few hard coded strings added for
the text to e-mail...

"Simon Hayes" <sql@hayes.ch> wrote in message
news:40c750bb$1_1@news.bluewin.ch...
>
> "Henok Girma" <reply@in.newsgroup.only.com> wrote in message
> news:GGGxc.72$FC3.55@bignews1.bellsouth.net...
> > Hello Gurus,
> > i have a very strange problem that is killing me..
> >
> > I have a stored procedure that e-mails, that stored procedure is called
> from
> > diffrent table triggers..
> >
> > on table a the trigers fires and e-mail.. everything is ok..
> >
> > on table b the triger fires and e-mail is sent however in IIS it's comes
> up
> > under the mailroot\Drop and never gets deliver.
> >
> > can someone please help me troubleshoot.
> >
> > let me know if you need more info.. what you want me to clarify.
> >
> > thank you in advance
> >
> >
>
> Which versions of MSSQL/Outlook/Exchange do you have? Is the trigger code
> exactly the same on both tables? Are you using SQL Mail or an external
mail
> tool? Can you post the piece of trigger code which sends the mail?
>
> Simon
>
>