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-12 : 07:48:45
|
| Donna writes "Well, I did look and I can't find it so I'm gonna ask. I am using XP, outlook 2002, exchange 2003 and Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1). I am using xp_readmail to get a list of attachments and save them to a directory. So I have @suppress_attach left at the default and am using the fully qual list of attachments in @attachments which I go thru and save away. It works brilliantly except it blimmin only uses the first 8 chars of the filename, because that's all it's getting back in @attachments. Is this xp_readmail, or outlook or exchanges fault and can I have the full filename? You'd be my hero's if you can tell me!" |
|
|
|
|
|
SQL xp_readmail @attachments returns 8 char filenames