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 |
|
magictech
Starting Member
44 Posts |
 Posted - 2005-02-24 : 15:20:02
|
| 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 'xyz\Robert.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 appreciatedRegards |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
magictech
Starting Member
44 Posts |
Posted - 2005-02-25 : 13:50:56
|
| Thanks for your respond. I went ahead a schedule a job using the NT ID that both SQL Server and SQL Agent runs under and it runs successfully. However, I've run into a more serious problem. The email that I get from xp_sendmail is empty. The email has only the column header information and does not contain any data. Has anyone ever seen this before. Please help this is an emergency |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-25 : 16:25:31
|
| Sending the results of sp_configure is an emergency? For emergencies, you can hire one of us to be a consultant for a few hours to help you out. Sorry couldn't resist, we offer free support here.Is the e-mail always empty regardless if you use @query or not? Try:EXEC master.dbo.xp_sendmail @recipients = 'SomeUser@SomeDomain.com', @Subject = 'Test', @Message = 'Test' Is the e-mail empty for the above?Tara |
|
|
|
|
|
|
Error Using XP_xp_sendmail with @query