Limit on the size of the select generated by "open table"?

microsoft.public.sqlserver.tools

1 Mar 2006 12:18 AM

Is there a limit to the size of the select statement that is generated by the
"open table" command in Sql Server 2005 management studio?

I can run what should be the same select (auto generated by "Script Table
as->SELECT to->New Query Edit Window") interactively. But, when I do a "Open
Table", I get an error that says:

SQL Execution Error.
Executed SQL statement: SELECT ..... (very long list of fields deleted)...
Error Source: Microsoft.VisualStudio.DataTools
Error Message: Exception has been thrown by the target invocation.

The length of the select run interactively is 11056 char.