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)
 xp_sendmail to a group

Author  Topic 

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2007-08-20 : 09:31:17
Hello All,

I have a stored proc which sends results to the users using xp_sendmail. Cusrrently I have hardcoded all the users in the recipient's parameter. Instead of using the names, I have created a new operator as' DBA Team' and I wanted to use this group with xp_sendmail instead of individual users.

Can anyone tell me how would I use the group in xp_sendmail proc?

Thanks in advance,
-P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-20 : 22:55:23
You need create a group on mail server and send mail to that group.
Go to Top of Page
   

- Advertisement -