xp_sendmail Recipients Query

[itsmarkdavies]

Can anyone tell me if there is a limit to the number of (or string length of) the @Recipients parameter to xp_sendmail ?

I know you can put the Recipients into a varchar string and then pass this, but I would like to know if there is a limit to the number of Recipients you can string together using the ";" separator in the @Recipients parameter.

Thanks.


itsmarkdavies@hotmail.com

 

[JamesLean]

I have found there is a limit of 255 chars for the @recipients parameters. This is SQL 7, it may have changed in SQL 2000.

--James

 

[itsmarkdavies]

Thanks for that James, I should be OK then !

itsmarkdavies@hotmail.com