Re: SQL Mail problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Foo Man Chew (foo_at_man.chew)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 14:35:07 -0500

So send your query to a text file (plenty of ways to do that) and then
attach it to the e-mail yourself...

"Pete" <Pete@discussions.microsoft.com> wrote in message
news:FAE52BC7-2D75-4BFF-82D4-0A56DE7F3391@microsoft.com...
> That works, though it won't do what I need because it doesn't offer @query
> support. Any work arounds? I'm trying to write some jobs and include query
> results as variables in this, but it doesn't look like it's going to work.
>
> "Tom Moreau" wrote:
>
>> Check out:
>>
>> http://www.karaszi.com/SQLServer/info_no_mapi.asp
>>
>> --
>> Tom
>>
>> ---------------------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinnaclepublishing.com
>>
>>
>> "Pete" <Pete@discussions.microsoft.com> wrote in message
>> news:59E0C2D4-F61F-4CBD-B307-551AE5B859B7@microsoft.com...
>> I've got SQL mail set up to use a POP3 server over the internet, however,
>> whenever an xp_sendmail is executed against the database, it's putting
>> the
>> email into the SQLServices inbox instead of sending it to the outbox for
>> processing. I've tried installing both outlook 2003 and 2000 as clients
>> for
>> SQLServices and the same thing happens with both. I've look on
>> microsoft's
>> support pages, but all it told me was that in this instance, install
>> outlook
>> 2000 to fix the problem, which didn't.
>>
>> Help! Thanks.
>>
>>

Relevant Pages

  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Mail problems
    ... Any work arounds? ... I'm trying to write some jobs and include query ... > Columnist, SQL Server Professional ... > support pages, but all it told me was that in this instance, install outlook ...
    (microsoft.public.sqlserver.server)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)