Run .exe

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paulo - 11 Mar 2008 21:57 GMT

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!

Reply to this Message

Tibor Karaszi - 12 Mar 2008 08:46 GMT

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.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi, how are you doing?
>
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message

Greg D. Moore (Strider) - 13 Mar 2008 05:01 GMT

> 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!

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message