Jan 6, 2008 #1 steve728 Programmer Joined Mar 16, 2003 Messages 536 Location 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 Joined May 3, 2005 Messages 5,167 Location 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 Joined Oct 30, 2001 Messages 1,540 Location 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