Error while using xp_sendmail and @query | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error while using xp_sendmail and @query

I’m getting the following error message execute the following sql statement. SQL Statement —- EXEC xp_sendmail ‘rsmith’, @query = ‘sp_configure’ Error message —-ODBC error 8198 (42000) Could not obtain information about Windows NT group/user ‘xyzRobert.smith. The SQL Server version is 2000, the domain ID and the SQL Server is on the same domain.
However, I do have email alert up and running on this server. The following commands work just fine. EXEC xp_sendmail ‘rsmith’, ‘The master database is full.’ Has anyone else had this error message? Any help would be greatly appreciated
Regards
This KBAhttp://support.microsoft.com/?kbid=834124 has the required solution. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi magictech,
I’m having the same issue as you when I try to use xp_sendmail with @query option. I tried KB834124 suggestions, but it didn’t fix the problem and I’m wondering if you got it fixed.
TIA
Has anybody actaully solved this problem? The microsoft article is usless. I have 30 SQL Servers setup identicle to one another and only 2 have this problem. This is driving us nuts.
]]>