Facebook Twitter Reddit LinkedIn

How to export results of a stored procedure to a txt file

Run this in the DOS command line (arguments are case sensitive)

osql /U sa /P password /d pubs /S Server9 /Q "sp_help" -o ofile.txt

Source: http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspx
© 2007-2019 All rights reserved.   Part of the somuch.com group of trusted web sites.   PO Box 351031, Palm Coast FL 32135-1031