DTS to start a VB job on another server

When an entry is done on a table that has a trigger tied
to it, I would like to execute a Visual Basic program that
resides on another server. I tries making a DTS package
with the Execute Process task property. There is no
ability to pass a userid/password for a logon. I'm also
not sure, if this was even possible, would the program run
on that server or would is be pulled to the SQL Server and
actually run there?
Any info on if this is possible would be appreciated. If
there is some other method to allow an update to an entry
in the database trigger the running of the .exe on a
different server, that would be great to know.
TIA,
DougTry using the extended stored proc 'xp_cmdshell' to execute you exe...either map a drive to you sql server or provide the unc path......
Brad Feake
DB|||On the Win2k developement kit CD there is a file call exec.vbs which will
start a program on a remote server. The program will run in the remote
server's environment not the calling server. Use xp_cmdshell to start
exec.vbs.
"Brad Feaker" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7FD9BF-8DBC-407E-B34C-44D82FBC5410@.microsoft.com...
> Try using the extended stored proc 'xp_cmdshell' to execute you
exe...either map a drive to you sql server or provide the unc path.......
> Brad Feaker
> DBA
>