Re: how to: non-admin user sending email from a SP ?

From: Aaron Weiker (aaron_at_sqlprogrammer.org)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 11:20:33 -0800

Hello TR,
Check out using XPSMTP [1] for sending emails from inside of SQL Server.
All you would have to do then is grant the appropriate people permission
to call this procedure and you would not be relying on CDONTS.

1: http://www.sqldev.net/xp/xpsmtp.htm 

--
Aaron Weiker
http://aaronweiker.com/
http://sqlprogrammer.org/
> Whenever users insert a row into a particular table, I want an insert
> trigger to invoke a stored proc that sends an email. I want to have
> this
> email be sent right away and would prefer to avoid using a daemon
> process
> that examines a queue periodically. Nor do I want to use any
> client-side
> coding. We're using SQL 2000; the datbase server does not have IIS
> installed.  CDOSYS seems to be a way to go, but I'm not sure. An
> article I
> found at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;312839
> states that "Only members of the sysadmin fixed server role can run
> the OLE
> Automation stored procedures". The users on our system will not be
> members
> of the sysadmin role.  Will we run into permissions obstacles? Who is
> the
> user when an insert trigger invokes a SP --is it the user who inserted
> the
> row?
> Thanks
> TR

Relevant Pages

  • Re: SQL Server execute permission denied on object
    ... This is a permission problem: the Login account or the required permissions ... have not been set up properly on the remote database. ... Recently the SQL part was moved to a new server. ... SQL Server execute permission denied on object ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Export to Excel
    ... maybe your dts-script has no permission to the file/directory ... server through Enterprise Manager. ... package from SQL server. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSCESA20.DLL - Pull crashes IIS 5.0
    ... are you saying use File Explorer on the SQL Server machine and ... >>> RDA Pull request gets to the IIS server, ... >>> Server is running on SERVER2, you would add permission ... >>> ..NET Compact Framework MVP ...
    (microsoft.public.sqlserver.ce)
  • Re: Recommended Procedure for Importing From Access Across LAN
    ... For this the SQL server Service startup account should be ... >a domain account with read only permission in the folder where the file ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL Server Roles
    ... SQL Server Agent Jobs. ... We hoped to be able to build a new fixed server role ...
    (microsoft.public.sqlserver.security)