Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-22 : 08:13:42
|
| remix writes "Hi SQL Team,I use sql2000 at work and use xp_sendmail, and sp_makewebtask quite often.I just hung my personal website at a webhost that offered sql server as an add on. I went to use xp_sendmail, in some of my own stored procs, and in "jobs" in sql server agent. However...... they can't execute since the extended stored procs are in the 'master' db, and I don't have user rights in the webhost's master db.How can I get around this problem ? Thanksremix." |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-22 : 08:17:15
|
| The only way is to ask the webhost people to give you the correct permissions. And hope that they have SQLMail set up on their server. |
 |
|
|
chrissy
Starting Member
17 Posts |
Posted - 2003-05-22 : 11:56:15
|
| or could he also copy the stored proc from his sql machine to the new one in his db?but yeah, i dont think many webhosts have sqlmail setup :| |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-22 : 12:16:40
|
I doubt they have it set up, but you would need to confirm with your host. quote:
or could he also copy the stored proc from his sql machine to the new one in his db?
These are extended stored procs, so they are found in sqlmap70.dll. It's not as easy as just recreating some T-SQL.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
using xp_sendmail with a webhost