SQL Mail with query parameter doesn't work 
Author Message
 SQL Mail with query parameter doesn't work

Hi there,

I setup SQL Mail and it works all fine when I use the
SQLServer service user account.
Also if I start a SQLQuery Analyser session with my own
account (sa rights on the server) I can use xp_sendmail  
with the parameters recipients and message. But as soon as

the following error (after 2 minutes{*filter*}).

ODBC error 8198 (42000) Could not obtain information about
Windows NT group/user 'CORP\xxxxxx'.

I can run the query itself without problem
What can be the reason for that ?
I have also windows server admin rights on this machine.



Fri, 06 Jan 2006 16:21:15 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

2. Query works in SQL Query Analyzer but doesn't work in DTS

3. SQL Mail doesn't work but SQLAgentMail works on prod server

4. SQL Mail doesn't work...

5. SQL Mail doesn't work after SP2

6. SQL Mail doesn't work after ugrading to SQL2K

7. SQL DEBUGGING DOESN'T WORK WITH DATETIME PARAMETERS

8. Query using SQL doesn't work

9. SQL 2000 Query Analyzer Debugger doesn't work

10. [SQL Query in view doesn't work]

11. Query built in Access doesn't work in SQL Server

12. RDO Query on system tables doesn't work with sql 7


 
Powered by phpBB® Forum Software