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 |
|
ricardo
Starting Member
1 Post |
Posted - 2002-09-10 : 13:12:08
|
| Hi People, I'm sorry for my English, but it's so basic. I'm Brazilian. Now I need help... Do you help me? I need send email by T-SQL, but i don't have Microsoft OutLook or Exchange server. I think I can execute one application (done in Delphi), which will do this for me, with stored procedured (xp_cmdshell). But there's a problem here, if I use SQL Server 2000 on Windows ME I can execute this, but if I use SQL Server 2000 on Windows 2000 like administrator,Ii can't execute this. It's a big problem for me. Anybody help me? Ricardo ricardinho_rio@yahoo.com.br |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-10 : 16:46:10
|
| What happens when you try to run it?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-10 : 18:03:25
|
| Do you have an SMTP mail server running? One comes with Windows 2000. If so, you might try the ideas in Merkin's article here: [url]http://www.sqlteam.com/item.asp?ItemID=5003[/url] |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-09-14 : 09:35:40
|
| you need to have a SMTP mail server running to send the mails |
 |
|
|
|
|
|