xp_sendmail with long text messages

[Yorn Ziesche]

Hi everybody,

i try to send messages longer than 7990 characters from a text field
in SSQL2000. Unfortunatly the messages get cut off after 7990
character.

I did everything which is described in BOL (see below). It does not
solve the problem. Upgraded to newest Outlook Client and tried to send
as an attachment also. No success though.

Does anybody have a hint before i contact Microsoft.

Regards
Yorn Ziesche

E. Send messages longer than 7,990 characters

This example shows how to send a message longer than 7,990 characters.
Because message is limited to the length of a varchar (less row
overhead, as
are all stored procedure parameters), this example writes the long
message
into a global temporary table consisting of a single text column. The
contents of this temporary table are then sent in mail using the
@query
parameter.

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_s endmail 'robertk',
@query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

[John Bell]

Hi

This is documented in BOL as 8000:
[@message =] 'message'

Is the message to be sent. message can be up to 8,000 bytes.

See:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ts q
lref.chm::/ts_xp_aa-sz_6hbg.htm

At a guess you also have some control characters to give 7990.

You may want to use attachments or xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm

John

"Yorn Ziesche" <y.*******@vhb. de> wrote in message
news:df******** *************** ***@posting.goo gle.com...

Hi everybody,

i try to send messages longer than 7990 characters from a text field
in SSQL2000. Unfortunatly the messages get cut off after 7990
character.

I did everything which is described in BOL (see below). It does not
solve the problem. Upgraded to newest Outlook Client and tried to send
as an attachment also. No success though.

Does anybody have a hint before i contact Microsoft.

Regards
Yorn Ziesche

E. Send messages longer than 7,990 characters

This example shows how to send a message longer than 7,990 characters.
Because message is limited to the length of a varchar (less row
overhead, as
are all stored procedure parameters), this example writes the long
message
into a global temporary table consisting of a single text column. The
contents of this temporary table are then sent in mail using the
@query
parameter.

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_s endmail 'robertk',
@query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

[Yorn Ziesche]

John,

BOL explicitly states a way to send messages longer than 7990 Bytes (example
below).
I thought this is related to the length of the resultset.

Yorn
"John Bell" <jb************ @hotmail.com> schrieb im Newsbeitrag
news:sC******** ***********@new s-text.cableinet. net...

Hi

This is documented in BOL as 8000:
[@message =] 'message'

Is the message to be sent. message can be up to 8,000 bytes.

See:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ts q lref.chm::/ts_xp_aa-sz_6hbg.htm

At a guess you also have some control characters to give 7990.

You may want to use attachments or xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm

John

"Yorn Ziesche" <y.*******@vhb. de> wrote in message
news:df******** *************** ***@posting.goo gle.com...

Hi everybody,

i try to send messages longer than 7990 characters from a text field
in SSQL2000. Unfortunatly the messages get cut off after 7990
character.

I did everything which is described in BOL (see below). It does not
solve the problem. Upgraded to newest Outlook Client and tried to send
as an attachment also. No success though.

Does anybody have a hint before i contact Microsoft.

Regards
Yorn Ziesche

E. Send messages longer than 7,990 characters

This example shows how to send a message longer than 7,990 characters.
Because message is limited to the length of a varchar (less row
overhead, as
are all stored procedure parameters), this example writes the long
message
into a global temporary table consisting of a single text column. The
contents of this temporary table are then sent in mail using the
@query
parameter.

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_s endmail 'robertk',
@query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

[John Bell]

Hi

Sorry I didn't read to the bottom of the message..

Unfortunately I can't check this out at the moment, but other posts indicate
that attachments are not needed, therefore I assume that it does work on the
latest service packs.

John

"Yorn Ziesche" <y.*******@vhb. de> wrote in message
news:3f******** *************@b usinessnews.de. uu.net...

John,

BOL explicitly states a way to send messages longer than 7990 Bytes (example below).
I thought this is related to the length of the resultset.

Yorn
"John Bell" <jb************ @hotmail.com> schrieb im Newsbeitrag
news:sC******** ***********@new s-text.cableinet. net...

Hi

This is documented in BOL as 8000:
[@message =] 'message'

Is the message to be sent. message can be up to 8,000 bytes.

See:

mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ts q

lref.chm::/ts_xp_aa-sz_6hbg.htm

At a guess you also have some control characters to give 7990.

You may want to use attachments or xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm

John

"Yorn Ziesche" <y.*******@vhb. de> wrote in message
news:df******** *************** ***@posting.goo gle.com...

Hi everybody,

i try to send messages longer than 7990 characters from a text field
in SSQL2000. Unfortunatly the messages get cut off after 7990
character.

I did everything which is described in BOL (see below). It does not
solve the problem. Upgraded to newest Outlook Client and tried to send
as an attachment also. No success though.

Does anybody have a hint before i contact Microsoft.

Regards
Yorn Ziesche

>E. Send messages longer than 7,990 characters
This example shows how to send a message longer than 7,990 characters.
Because message is limited to the length of a varchar (less row
overhead, as
are all stored procedure parameters), this example writes the long
message
into a global temporary table consisting of a single text column. The
contents of this temporary table are then sent in mail using the
@query
parameter.

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_s endmail 'robertk',
@query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab