• Of course there really isn't a max length on System.String in .net. Well there is but it is totally huge. You are now trying to get the field size of underlying tables from a view.

    You could use

    select sc.* from sysobjects so

    join syscolumns sc on sc.id = so.id

    where so.name = 'your view name here'

    You will have to look at the xtype column to determine the datatype and the length column. Remember that if the column is nchar, nvarchar that the max length is half of the length because it takes 2 bytes to store each character. I found a decent listing of xtypes as related to columns here. Maybe this will get you in the right direction?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/