Posted by NiTiN on 10/02/07 11:54

--SNIP --

> The records , in the text file, have a size bigger then 8060. So we
> wont be able to import the text file.
> On the other hand it is said that Sql Server 2005 can get a record
> bigger then 8060 but
> again we couldnt be able to perform the task.
>
> As a result, i urgently need to know that how may i import the text
> file which has a record bigger then 8060 characters.?
> Any help is appreciated

-- SNIP --


Good day,

If you're using a large data-type for a column (such as varchar(max),
nvarchar(max), varbinary(max), text, image, & xml), you can go beyond
the 8060 limit.

Alternatively, if you aren't using large data-types, you can vertically
partition the table so some of the columns would be in one table while
the other set of columns would be in another table.

Hope this helps.

Regards,
N.I.T.I.N.

• Next in forum: Problems when trying to build Connection to SQL Server Express from ASP.NET application
• Prev in forum: Set time for UTC
• Thread view: Re: Having Problem While Importing a Text File

[Reply to this message]