[dba-SQLServer] BCP out, records affected

jwcolby jwcolby at colbyconsulting.com
Thu Jul 29 19:35:49 CDT 2010


I am running a stored procedure to BCP out a chunk of records.  The stored procedure uses

	exec master..xp_cmdshell @sql

to perform the BCP out.

Is it possible to get a "records affected" back from command shell ofr the SQL statement executed? 
If not is there another way to do this?

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list