Actually Remi,

There were 70 tables that qualified for the query, and the total bytes was about 7200.  None of which helps to explain why The variable is being limited to...

From BOL:

[N]'tsql_string'

Is a constant string. tsql_string can be of nvarchar or varchar data type. If the N is included, the string is interpreted as nvarchar data type with a...

This is for display only in QA and char(10) works just fine.

Giving the customer what he asked for.

Should read:

Declare @SQL varchar(8000),

 @TableName varchar(128)

select @SQL = ''

-- select len(@SQL)

-- select datalength(@SQL)

select @SQL = @SQL + 'Create View vw_' + name + char(10) +

              'AS' + char(10) +

              'select *...

QA screen output size was set to 8000.

Declare @SQL varchar(8000),

 @TableName varchar(128)

select @SQL = ''

-- select len(@SQL)

-- select datalength(@SQL)

select @SQL = @SQL + 'Create View vw_' + @TableName + char(10) +

             ...

Break the SQL statement into two statements with a UNION operator.  This should allow for an index seek on ends of the sql statement.

You are looking for the SP:  sp_OACreate.  Calling this SP will allow you to create a file handle to a file on the disk, which you can then use to...

I do not believe that one needs exclusive access to a database as I have shrunk databases on the fly in the past.

I have encountered this problem though whenever a...

I would try a couple of things.  Open the table in EM and move to the 13620 row.  It's possible that you have injected one or more non-printing characters in...