January 20, 2004 at 4:04 am
Hi, I've done the hard work of setting up the tables, triggers and stored procs and now I'm stuck on what I expected to be easy. I need to issue a net send command from a trigger. I know how to do this but I can't insert 'new line commands' and format the message as I require.
I want to display something like
The following items are out of stock
Product1
Product2
Product3
January 20, 2004 at 5:34 am
Not a solution, but just a note.
Wouldn't sending a mail be better?
I've made the experience, that if you don't explicitely tell your users about sending a message, they commonly close this nasty pop-up without actually reading it.
just my $0.02 cents
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 20, 2004 at 7:31 am
Oh man, how much do I agree, I've tried telling the boss and the project manager over and over again. It falls on deaf ears. I KNOW that within 2 months the users will be sick to death of net send messages telling them that they require more items than they have planned to produce and I will be asked to use xp_sendmail or something similar. Plus they haven't planned on logging any data from the trigger so after the user is interrupted from whatever they were doing and they click OK in anger, they will probably think 'oh, what product was that?'
Your $0.02 could save our company time and money but that's bad planning I guess!
January 20, 2004 at 7:35 am
What about telling your boss, that a mail is a kind of CYA strategy.
That will be the only way to prove that your application is working as it should. You can always say: Hey, look at this copy of the mail we've sent you.
No chance for the user to lie, he never received such an alert message.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply