How to use SQL Server to email information

From: Rathtap (amcniw_at_yahoo.com)
Date: 05/06/04 

Date: 6 May 2004 06:08:09 -0700

I have an .Net application that is watches a folder and imports
medical claim information into SQL Server whenever a file is dropped.
It then creates a file with a list of those claims that may have been
incorrectly billed based on certain criteria. I would like SQL Server
to send an email to certain recipients after each import with a link
to the file that was created so that they can do follow-up work on
those claims.
How do I do it? Code samples will be much appreciated since I am kind
of new to this.

Relevant Pages

  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... I was wondering what the significance is to sharing the snapshot folder. ... Does the Pocket PC directly access the shared folder? ... >> check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: Build
    ... As Kalen already mentioned, there is no such thing "build" in SQL Server, that term is must be about "Building a Project or Solution in Visual ... here you are talking about a specific application which seems to need more than one database and noone here except for you knows about the sample application you are working on now. ... From what I've learned, there are actually several databases that exist for every "solution", located in the output folder and project folders. ... If you can explain what you mean by "build" and some examples of what files you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
Loading