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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-06 : 07:38:51
|
| Aaron writes "I have been using SQL Server for years now (from 6.5, through 7, 2000 and now 2005 on some servers) and have never really had the need to use SQL Mail at all. Now, a client of mine wants me to be able to retreive mail sent to a given email address, parse through it to collect various pieces internal to the message body and store those pieces in a dB. Now, I'm also a VB guru so the parsing stuff is cake - what I need help with is the SQL piece.From a book I have, it says that "The SQL Server inbox is really just a table that stores certain information about the email message such as the sender, subject, CC list and message text."So, I have been looking for (and my question is) the name of the table (presumably in the Master dB, but I couldn't find it) where this inbox info is stored!Note: I don't want to use the stored procedures (i.e. xp_readmail) as I need to do some custom "processing" of the message text. I just want the name of that table." |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-06 : 07:49:30
|
I'm not aware of any such table, so I reckon you need to make your own.I've been wrong before though! ... in which case someone will be along in a minute to correct me  Kristen |
 |
|
|
theitguyinny
Starting Member
1 Post |
Posted - 2006-10-09 : 10:56:12
|
| Where, then, do you believe, the data is stored? The reason why I'm asking is that I'm having a real problem with the syntax of the SQLMail associated stored procedures (xp_readmail, processmail, etc.) They won't work for nothing - note that I have a clean install of SQL Server 2000 on 1 machine and 2005 on another - no customizations. I would love to get some ready-to-copy-and-paste commands to read mail, since the SQL Server Books Online versions just don't function at all as copy-and-paste.Alternatively, since I like the flour-and-water stuff better, anyway, I'm [again] really interested in the table name for the sqlmail inbox so I can just query it and delete records (emails) as I see fit. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-09 : 12:10:14
|
| Good luck finding that table.If you do find it, please let us know what it is.CODO ERGO SUM |
|
|
|
|
|
|
|
|
SQL Mail Inbox table name