InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 23:39:45 GMT20http://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspxI don't really understand the question. Do I have to specify a limit? No. I did try the set textsize option but this did not change the output for me.Thu, 11 Oct 2012 08:27:52 GMTsqlrd22http://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspxHave to specified any size limit to the output file??Thu, 11 Oct 2012 08:22:10 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspx[quote][b]Chrissy321 (10/10/2012)[/b][hr]This thread looks promising as a solution....http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460http://msdn.microsoft.com/en-us/library/ms186238.aspx[/quote]Sadly, this didn't work for me.Thu, 11 Oct 2012 02:30:55 GMTsqlrd22http://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspxThanks, I'll give it a go tomorrow.Wed, 10 Oct 2012 14:02:56 GMTsqlrd22http://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspxThis thread looks promising as a solution....http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460http://msdn.microsoft.com/en-us/library/ms186238.aspxWed, 10 Oct 2012 11:18:21 GMTChrissy321http://www.sqlservercentral.com/Forums/Topic1371007-1550-1.aspxI have an SQL Server Agent job running every day at 9am to run a query and using the Advanced tab in the specific step to run the query I send the output of the query to a CSV file. However, when checking the CSV file, only half of the results of the query display.I'm using SQL server 2008 r2 and I save it to a CSV file on the network and then open it with Excel 2007 on my Windows 7 professional PC. When I run the query itself outside of the job and save the results to a CSV file, the whole results show.Any help greatly appreciated.Wed, 10 Oct 2012 09:28:43 GMTsqlrd22