"aerick" <aezza@msn.com> wrote in message news:066701c380c6$25f2e0a0$a401280a@phx.gbl...
> hi,
>
> I'm having a problem with xp_sendmail.
> I've tried the following from query analyser with sa as
> the user:
>
> exec master..xp_sendmail @recipients='aezza@msn.com',
> @subject='test',@message='test message', @query='select
> top 1 * from TestDB..TestTable'
>
> with the following result:
> ODBC error 4604 (42000) There is no such user or
> group 'sa0'.
>
> However, if i execute the exact query without the @query
> argument i get an email.
>
> Can anyone shed some light on the issue?
> thanks,
>
>

>-----Original Message-----
>I would try adding N in front of the/some string
parameters, to see if there's something strange
>with xp_sendmail expecting Unicode data.
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>
>"aerick" <aezza@msn.com> wrote in message
news:066701c380c6$25f2e0a0$a401280a@phx.gbl...
>> hi,
>>
>> I'm having a problem with xp_sendmail.
>> I've tried the following from query analyser with sa as
>> the user:
>>
>> exec master..xp_sendmail @recipients='aezza@msn.com',
>> @subject='test',@message='test message', @query='select
>> top 1 * from TestDB..TestTable'
>>
>> with the following result:
>> ODBC error 4604 (42000) There is no such user or
>> group 'sa0'.
>>
>> However, if i execute the exact query without the
@query
>> argument i get an email.
>>
>> Can anyone shed some light on the issue?
>> thanks,
>>
>>
>
>
>.