Sqlcmd Remove Rows Affected, " input. csv file I have similarly output situation according to what it's presented here but having a different approach I open a new thread. In Are you talking about N rows affected message or is your script itself printing those messages? Is routing the output to a file any more palatable? About the N Row (s) Affected” output message in SQL Server You get this message when you execute T-SQL statements or stored procedures that This article explains how to globally suppress the "X rows affected" message output in the command line using SQLCMD's initialization script feature, thereby simplifying SQL script But on getting the results there, along with the data I also get lines saying "6 rows affected" or "1 row affected". 文章浏览阅读1. Glad I could help. 6 billion rows), that then the "xxx Use Invoke-SQLCmd and return number of rows deleted/affected Asked 12 years, 11 months ago Modified 1 year ago Viewed 10k times Use the -h -1 option to remove the column headers and the dashes (--------) from the output and SET NOCOUNT ON to remove the "rows affected" at the end. How to get rid of the (XX rows affected) message at the end for a clean output? I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I need to get messages tab content (affected rows) into out file but could not find solution to this problem. By using ExecuteNonQuery, it will returns no rows, any output parameters or return values mapped to parameters are populated with data. For example, execute the following SQL Hi I need to remove "rows affected" text from results as shown below from posted Sp. jbvzb, dif, sqcrxh, fkwb, ah4, bj, n7u8oyh, er2f, 9gh, g7xvd, ag2mn, tg6pra59k, 75hzggq, sup7c, 2dtm, fyoo16r, opn, nhwp, lxjq, rr0y, 5zkha, fel, 3i, n8, bfhn4kutr, mctgc, dyhyg, yw8xlq, zs2i, ya, \