SQL xp_findnextmsg and xp_readmail
If you use SQL mail, you can read the messages in the SQL inbox stack and do stuff with them. Recently I had to use SQL scripting to find messages in the SQL inbox, read the message, determine if it is a text or html email, then add the message to a table in [...]
Database Mail vs SQL Mail in SQL Server 2005
SQL Mail was what one would use to send emails from SQL Server in the SQL Server 2000 version. But in SQL Server 2005, SQL Mail is considered legacy. Microsoft introduced a better email component called Database Mail for SQL Server 2005.
In SQL Mail, you can run the xp_sendmail stored procedure to send [...]
-
Recently Written
- Quick guide on how to take screenshots on a Mac
- SQL xp_findnextmsg and xp_readmail
- 31 Days to Build a Better Blog challenge!
- What is Joomla’s Community Builder extension?
- Listen to your iPod while you drive
- Twitter Weekly Updates for 2009-05-03
- Implement Ajax CollapsiblePanelExtender in ASP.NET page
- C# quick example of handling Infinity and NaN
- Twitter Weekly Updates for 2009-04-26
- Twitter Weekly Updates for 2009-04-19
-
Recently Commented Posts
-
Blogroll
Top Commentators
- What is Jayrock? Download here http://jayrock.berlios.de/ 2 weeks ago
- JSON: The Fat-Free Alternative to XML http://www.json.org/xml.html 2 weeks ago
- Can anyone explain the difference between the laws of God and the principles of God? #Bible 2 weeks ago
- More updates...
Posting tweet...
Powered by Twitter Tools
Josh`s Sanctum
Blogroll Me!
Directory
Copyright © 2007-2008 ashchuan.com – Web Technology • Using Modernpaper theme created by Performancing