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 |
|
KlausJensen
Starting Member
14 Posts |
 Posted - 2001-01-25 : 18:31:59
|
| Hi!I need to be able to send out mails from a stored procedure, and using SQL Mail is not an option.I use sp_OACreate and sp_OASetProperty to create a CDONTS.Newmail object and set properties.This works great, but when a property exceeds 255 characters, I run into trouble, and the text is truncated at 255 chars! I have found a bug report on MSDN, stating that this is a known bug (http://support.microsoft.com/support/kb/articles/Q278/4/48.ASP).Does anyone know of another way to call com-objects from T-SQL or some kind of workaround?- Klaus---Klaus JensenInternet Developer1eEurope Denmarkhttp://www.1eEurope.dk |
|
|
|
|
|
Calling COM-objects from T-SQL