Go Back  Xtreme Visual Basic Talk > Visual Basic .NET (2002/2003/2005/2008, including Express editions) > .NET Database and Reporting > SQL Server 2005 Triggers + VB.Net


Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2006, 01:45 PM
Nayru's Avatar
Nayru Nayru is offline
Centurion
 
Join Date: May 2006
Location: GTA
Posts: 119
Default SQL Server 2005 Triggers + VB.Net


I am trying to write an application that will send out emails every time a row in a certain database table is updated using SQL Server 2005 and VB.Net 2005. The database is one our IT department uses to track work orders and they want users to be emailed notifications when work is done, the ticket is reassigned etc. to try and cut down on the phone calls they get bogged down with.

In theory it looks pretty simple... Excep the database doesn't have an Assemblies folder so I can't add a .dll to trigger. I've never set up a trigger to call an external application before so this is all new to me.

Does any one know of a way to "add" the assemblies folder, or any sort of work arounds to get a trigger calling an external app? Everything I've been able to find relies on having a DLL added to assemblies.

Thanks a lot.
Reply With Quote
  #2  
Old 10-04-2006, 02:03 PM
00100b's Avatar
00100b 00100b is offline
Martian In Disguise

Retired Moderator
* Guru *
 
Join Date: May 2003
Location: Minneapolis, MN
Posts: 9,566
Default

One option may be Database Mail.

Edit:
Ack, it doesn't like the link.

Just copy paste the following into the Address Bar

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/14cbf88f-d9d1-41a5-994e-532e2973ac9e.htm
__________________
The only stupid question is the one that goes un-asked.
Reply With Quote
  #3  
Old 10-04-2006, 02:18 PM
Nayru's Avatar
Nayru Nayru is offline
Centurion
 
Join Date: May 2006
Location: GTA
Posts: 119
Default

Link still didn't work, but google did.

That looks pretty useful, the only problem is there are some really cryptic fields in the database that will just confuse users, but they contain really relevant information. That's why I was leaning towards an external app, I could use the program to "decode" the tech speak for the users (this was a requirement from the boss so I can't really get out of it).

Thanks a lot for the suggestion, that could've worked great if we had better data in the database
Reply With Quote
  #4  
Old 10-04-2006, 02:24 PM
wayneph's Avatar
wayneph wayneph is offline
Web Junkie

Retired Moderator
* Expert *
 
Join Date: Apr 2004
Location: D/FW, Texas, USA
Posts: 8,393
Default

Why Create an Assembly? SQL 2005 has "Database Mail" included:

http://msdn2.microsoft.com/en-us/library/ms175887.aspx
__________________
-- wayne, MSSM Retired
> SELECT * FROM users WHERE clue > 0
0 rows returned
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->