How do I execute xp_sendmail on a shared SQL Server ?

From: CS (charles.steneck_at_aa.com)
Date: 06/25/03 

Date: Wed, 25 Jun 2003 13:04:53 -0700

Hi Everyone,

I have a webhost that offers SQL2000.
I have been executing my own stored procs without a
problem. I just tried to execute xp_sendmail and
sp_makewebtask..... However.....since it is a shared
SQLServer..... I dont have permissions on the 'master' DB.

Any Ideas on how I can execute extented stored procs in
this scenario ?

(they told me they obviously couldn't give me permissions
in the master db)

So do I lose all of the functionallity of extended stored
procs, just because of this secuity issue ????

Thanks CS.

Relevant Pages

  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... App1 contains CRUD functionality using stored procs (EXEC perms on ... UpdateResearch stored procs. ... execute UpdateResearch. ... view-level permissions such that we can permit/deny a database action ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... App1 contains CRUD functionality using stored procs (EXEC perms on ... Resarch group (of which he is also a member), ... execute UpdateResearch. ... view-level permissions such that we can permit/deny a database ...
    (microsoft.public.sqlserver.security)
  • Re: Question about how to differentiate between user functions and stored procedures when using OLE
    ... > able to tell the differnce between stored procs and user functions through ... > connects to various databases, excel, access, sqlsvr, etc.via OLE DB. ... > trying to add functionality to this application to be able to execute ... > procedures and User functions(for SQL SVR at least). ...
    (microsoft.public.sqlserver.programming)
  • Re: execute sql task / stored procedure
    ... Stored procs have their advantages and they are well documented (cached ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... > is there some performance considerations when> using execute sql task - is it better to use a large ...
    (microsoft.public.sqlserver.dts)
  • Re: Custom sort records in a stored proc
    ... based on parameter, you execute the respective ... create another table that holds information like tablename, ... > I have several stored procs that return two columns of data - primary ... > specific primary key value and have the corresponsding record appear ...
    (microsoft.public.sqlserver.programming)