e-mail subject line issue - 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 Development (2000)

e-mail subject line issue

Author

Topic

mail2vasanth
Starting Member

1 Post

Posted - 2009-03-12 : 23:30:14

I send e-mail through SQL server using function

EXEC master..xp_sendmail

and my getting issues in my subject line

It's applying a tab character after 65 characters. This started happening after our microsoft exchange server upgraded to 2007 version.

e.g Subject line sent in the function: qwertyuiopqwertyuiopqwertyuiopqwertyuiopqwertyuiopqwertyuiop12345qwqwqw

it's getting generated as
qwertyuiopqwertyuiopqwertyuiopqwertyuiopqwertyuiopqwertyuiop12345 qwqwqw

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 01:23:28

Download http://sqldev.net/xp/xpsmtp.htm and install on SQL Server don't use SQL mail it is horrible tool.

This way you don't have to have outlook installed on your computer and XP_STMP is 100x better then SQL Mail on 2000 :).

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources