[dba-SQLServer] BCP out via cmdshell

jwcolby jwcolby at colbyconsulting.com
Wed Apr 14 11:09:51 CDT 2010


Can BCP queryout return a "records affected" kind of count to

exec master..xp_cmdshell @sql

so that I can pass that count out of the stored procedure back up to my C# program?

This is one of the very few stored procedures that use XP_CmdShell and so far I do not know how to 
get results back from XP_CmdShell.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list