question

palum avatar image
palum asked

Exe a sql server Sproc from unix command

Does anyone know how to execute a sproc from unix command. I could do it in oracle but i dnt know to do it in sql server. Below is the code to run a sproc from unix. sqlplus -s username/password@databasehostname << EOF set pagesize 10000; set echo off; set numformat 9999999999; set feedback off; set heading off; set trimspool on; set linesize 1024; exec store_procedure_name; exit EOF Please let me know if there is a way to exec a sproc from unix.
sql-server-2005unix
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
MVP Erland Sommarskog has written an article on SQL Server/UNIX connectivity: http://www.sommarskog.se/mssqlperl/unix.html Hope this helps.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.