Command Line execution of a Stored Procedure?

[Kristin Piskulic]

Is is possible to execute a Stored Procedure from the command line? If so,
how? We are wanting to make a short cut on a users desktop to run a stored
procedure.

Thanks,
Kristin

[Michael Levy]

You can use isql.exe for 6.5 or osql.exe for 7.0.

osql -Sserver_name -E -ddatabase_name -Q"EXECUTE spname parm1, parm2"

type osql /? at a command prompt for the complete list of options.

-Mike

--
Michael Levy MCSD, MCDBA, MCT
Consultant
GA Sullivan
michaell@gasullivan.com