readmail-question - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

readmail-question

Author

Topic

noelson
Starting Member

31 Posts

Posted - 2001-03-20 : 00:59:24

In Query Analyzer,
USE master

declare @status int
declare @msg_id varchar(64)
declare @originator varchar(255)
declare @cc_list varchar(255)
declare @msgsubject varchar(255)
declare @query varchar(255)
declare @messages int
declare @mapifailure int
declare @resultmsg varchar(80)
declare @filename varchar(12)
declare @current_msg varchar(64)

EXEC @status = xp_readmail @msg_id = @msg_id,

@originator = @originator OUTPUT,

@cc_list = @cc_list OUTPUT,

@subject = @msgsubject OUTPUT,

@message = @query OUTPUT,

@peek = 'TRUE',

@suppress_attach = 'TRUE'

Insert into test.dbo.mail values(@status,@msg_id,@originator,@cc_list,@msgsubject,@query,@mapifailure,@resultmsg,@filename,@current_msg);

In the result in the query, I got lots of data but in the end it stated only I got
(1 row(s) affected)

why I only got 1 row?

In the Mail table, only status had data the rest is null!

any ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources