Try, SET NOCOUNT ON
"ON" on "OFF" On Fri, Aug 7, 2009 at 4:17 PM, Rakesh <[email protected]> wrote: > > Hello every One. > I have created the file by usimg OSQL command in SQL Server 2000 for > inserting the data from my particular table. The records got inserted > in the file successfully ,but the proble is regarding the output.. > at the end of file there is one statement (130 Rows Affected) if 130 > rows of table got inserted in the file. > > I want to delete (130 Rows Affected) this line from my file. > > I used set NOCOUNT off in select statement but no use ??? > How to remove it. Can plz help kme out > > in Advance thankx. >
