Varchar (8000) problem 1

[beckwiga]

I had to import several extremely large, comma delimited text files into my SQL Server db. I didn't notice at first, but all my fields are VarChars of size 8000! Most all of my fields do not exceed 30 in length, and I want to redefine them all as nChar of size 30. Is there an easy way to do this without doing it manually? I have a lot of fields and a lot of tables. If I reimport my text files with DTS, can I set the type and size someplace? It defined them like this by default.

Any help would be appreciated.

 

[mrdenny]

When using DTS you can modify the transfermation properties that is uses to create the tables and specify different column sizes. You'll need to modify each table and column manually however.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[beckwiga]

Thanks, Denny.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)