Run .exe

Hi, how are you doing?
Can I run a .exe inside a SP? Because before sending emails it needs to
authenticate, so I did a Delphi .exe !
MS SQL 2000
Thanks!Yes, by using xp_cmdshell. However this is a really ugly thing, and whatever is performed will
probably be lost after the scope of xp_cmdshell.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Paulo" <prbspfc@.uol.com.br> wrote in message news:ub89Zq7gIHA.3352@.TK2MSFTNGP04.phx.gbl...
> Hi, how are you doing?
> Can I run a .exe inside a SP? Because before sending emails it needs to authenticate, so I did a
> Delphi .exe !
> MS SQL 2000
> Thanks!
>|||"Paulo" <prbspfc@.uol.com.br> wrote in message
news:ub89Zq7gIHA.3352@.TK2MSFTNGP04.phx.gbl...
> Hi, how are you doing?
> Can I run a .exe inside a SP? Because before sending emails it needs to
> authenticate, so I did a Delphi .exe !
>
Yes you can do this, but don't.
There's a lot of things that can go wrong here, including xp_cmdshell
hanging and tying up resources.
And then of course there's just the time involved.
> MS SQL 2000
> Thanks!
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html