mshen Apr 8, 2009   2:10 AM GMT

What version of Unix/Linux are you using or is it on a windows machine?

27,385 pointsBadges:

Denny Cherry Apr 8, 2009   8:41 PM GMT

As SQL Server only runs on Windows, are you trying to run a Unix script on Windows, or do you need to log into a Unix server then run the Unix script?

68,435 pointsBadges:

VelameLaCosa Apr 16, 2009   5:32 PM GMT

The stored procedure itself will run on a Windows 2003 Server (SQL 2005). The script should connect to a Solaris 10 (UNIX) box to execute some commands.

110 pointsBadges:

petkoa Apr 20, 2009   11:07 PM GMT

> > The stored procedure itself will run on a Windows 2003 Server (SQL 2005). > The script should connect to a Solaris 10 (UNIX) box to execute some commands. > So, then the easiest way will be to write and put shell script on the UNIX box, then the stored procedure should just call rsh/ssh client and execute the script. Sure, you should (1) install some windows port of rsh/ssh on win2003 system, and (2) make arrangements for the non-interactive login (e.g., non-password protected ssh private key on win2003 system, or some rhosts assignments on the solaris system - of course, the environment should be secure enough). My advice would be to go with ssh - not because of encryption and security, unattended login should create security hole anyway, but because of ease of setup: rsh is a protocol quite tricky for firewalls. BR and good luck, Petko

3,140 pointsBadges: