Hi,
If I execute a stored procedure in VS 2005 that generates long lines of output they are truncated at 256 character maximum. Is there a way to increase this limit?
Thanks,
Pat G.

Which API do you use to output strings in question?

Re-reading my original post, I was not very clear about waht I am doing. While in VS 2005, I am opening our SQL 2003 server in ServerExplorer and chooisng a stored procedure from one of our databses. I then right-click and execute. We have stored procedures that read through some tables and auto-generate some lines of code. It shuold generate some asp code and vb code to cut-and-paste into asp.net forms I am developing. This works well except for some very long lines. The procedure below is a simplified demonstration of the problem:

= = = = =
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER             PROC dbo.xsp_PGtest
AS

CREATE TABLE #ScriptFile
 (LineText varchar(350))

INSERT INTO #ScriptFile
 (LineText)
 SELECT CHAR(13)
  +  'Line 1:xx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'
  + 'xxxxxxxxx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'
  + 'xxxxxxxxx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'

INSERT INTO #ScriptFile
 (LineText)
 SELECT  CHAR(13) 
  + 'Line 2:xx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'
  + 'xxxxxxxxx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'
  + 'xxxxxxxxx1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx4xxxxxxxxx5'
  + 'xxxxxxxxx6xxxxxxxxx7xxxxxxxxx8xxxxxxxxx9xxxxxxxx00'

SELECT *
FROM #ScriptFile

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
= = = = =
What this should do is store two lines of 300 characters each in a temporary table and then display the contents of the table to the output window. This runs ok in SQL Query Analyzer with output selected to TEXT and the Tools/Options/Results "Maximum characters per column" set to 350. However, I cannot find a similar option to increase the line size of the Output window in VS 2005.
Thanks,
Pat G.

I don't think it is VS fault really. Output window simply captures what is output via Win32 OutputDebugString API (which is not limited by length). However, if application that costructs strings before calling the mentioned API has a fixed buffer for the string construction, the string will be truncated. Is string getting chopped off or simply wrapped?

The string gets chopped off. If I enable line wrapping, the line wraps at the right edge of the output window but the second line still gets chopped at the same character position.