Jan 6, 2008 #1 steve728 Programmer Mar 16, 2003 536 US Will someone please refer e to help regading how to call a stored procedure from a command prompt? SQL Server 2000 - 2005. Win XP Steve728
Will someone please refer e to help regading how to call a stored procedure from a command prompt? SQL Server 2000 - 2005. Win XP Steve728
Jan 6, 2008 #2 bborissov Programmer May 3, 2005 5,167 BG Check "Command Prompt Utilities" in BOL Borislav Borissov VFP9 SP2, SQL Server 2000/2005. Microsoft MVP VFP Upvote 0 Downvote
Check "Command Prompt Utilities" in BOL Borislav Borissov VFP9 SP2, SQL Server 2000/2005. Microsoft MVP VFP
Jan 6, 2008 #3 hmckillop Programmer Oct 30, 2001 1,540 GB Many different ways, have a look at osql, isql, isqlw, sqlcmd( in 2005). Each of these are command line utilites to access sql. a sample being Code: osql /U sa /P password /d pubs /S Server9 /Q "sp_help" -o ofile.txt "I'm living so far beyond my income that we may almost be said to be living apart Upvote 0 Downvote
Many different ways, have a look at osql, isql, isqlw, sqlcmd( in 2005). Each of these are command line utilites to access sql. a sample being Code: osql /U sa /P password /d pubs /S Server9 /Q "sp_help" -o ofile.txt "I'm living so far beyond my income that we may almost be said to be living apart