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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 I need your Help, please, for God!

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.
Go to Top of Page

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]

Go to Top of Page

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

Go to Top of Page
   

- Advertisement -