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 Administration (2000)
 xp_sendmail in Clustering Environment

Author  Topic 

santha_sqlserver
Starting Member

7 Posts

Posted - 2000-10-25 : 16:37:54
xp_sendmail @recipients = 'yourname@email.com',
@message = 'Message',
@subject = 'Subject',
@query = 'select 10,20',
@attach_results = 'TRUE'

The above code works fine with all servers except CLUSTER servers. MAPI profile is configured correctly, since if i ran this query without @query and @attach_results, then the code is working fine. The error displayed in case of CLUSTER server is :

"Server: Msg 17969, Level 16, State 1, Line 0
Unable to login to SQL Server."

The error number : 17969 is an Undocumented error and hence i could not find anything in "Books on-line".

Can somebody help me out ?


Thanks in advance,


Santha.

Santha Kumar
   

- Advertisement -