How do I execute xp_sendmail on a shared SQL Server ?
From: James Miller (zrt9_at_cdc.gov)
Date: 06/26/03
- Next message: Len: "Log of Logins/Logouts"
- Previous message: nntp: "Re: Accessing SQL 2K from SQL 7"
- In reply to: CS: "How do I execute xp_sendmail on a shared SQL Server ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 09:31:51 -0700
Some of those procecdures should be perfectly safe for you
to use. I don't see why they couldn't give you access to
the specific procs in master that you need, without giving
you access to all of master. If they don't you really
can't execute any extended procs.
>-----Original Message-----
>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.
>.
>
- Next message: Len: "Log of Logins/Logouts"
- Previous message: nntp: "Re: Accessing SQL 2K from SQL 7"
- In reply to: CS: "How do I execute xp_sendmail on a shared SQL Server ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
