December 30, 2004 at 3:42 am
Hi,
Wants to read an ntext column and assign to local variable in stored procedure in sql 2000. But unable to do. As such I know that ntext cannot be read and assign if length of data is greater then 8000.
My problem is I am sending mails and mail content body is stored in ntext field and mail length is greater then 8k. For that I am using sql mail and that fires from job as per scheduled time and job invokes store proc from which mails are going out one by one to recipients. In delivered mail content gets cut.
Please let me know if there is any workaround of the problem.
Thanks.
Vikas
December 30, 2004 at 3:58 am
A quick search on this site (hint, hint ) returns this, which might be useful:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=7798
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 2, 2005 at 1:40 am
Hi,
TSQL has a problem that u cannot have a variable of TEXT/NTEXT datatype.I think the best way would be use a temp table
Create #SqlMailBody(MailBody TEXT)
and insert all the data into this text column and u can retrieve them as u require.
Regards,
Vasanth Kumar
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply