What version of Unix/Linux are you using or is it on a windows machine?
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?
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.
> 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,