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 |
|
donkyho
Starting Member
12 Posts |
 Posted - 2007-08-24 : 08:22:49
|
| I'm just wondering how to create a stored procedure that will send a simple email out to a given email address. Keep in mind that the SQL Server I'm connecting to is not owned by me, I connect remotely to a SQL Server that I purchased some space on, so I'm not sure I can install any type of add-ons, etc.Thanks! |
|
|
donkyho
Starting Member
12 Posts |
Posted - 2007-08-24 : 12:13:53
|
| is there any way of doing this without permissions to use SPs in the master DB? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-24 : 13:17:58
|
| no. and it's a bad idea anyway._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
donkyho
Starting Member
12 Posts |
Posted - 2007-08-24 : 13:45:30
|
| why is it a bad idea? Isn't it better to do it in a stored procedure rather than code? I guess I can just make a function for it, I just wanted to use the DB so I didn't have to code as much :) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-24 : 13:49:58
|
you already have a storred procedure for this. It's in master database to which it seems you don't have access to.so you can't do it anyway.it's a bad idea because it can block your transactions since it's a synchronous operation.but as long as you're not doing it in triggers it's not that bad  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Sending Email through Stored Procedure