Hi
I found that long strings are cut when import to the text file. Does it mean that something is wrong with my database definition or this is a real bug
I just defined test table with one varchar(6000) column. I put in string with 600 characters. After export to the text file, string was cut to the 232 chars. No error messages
Some idea

Thanks

Are you seeing something like this

http://support.microsoft.com/?kbid=247527

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
mean that something is wrong with my database definition or this is a real
bug?
[quoted text, click to view]
with 600 characters. After export to the text file, string was cut to the
232 chars. No error messages.
[quoted text, click to view]

I would say that this could be fixed with the latest service pack:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;290211

This SP will remove the following bug for sure, if you have similar problem.

http://support.microsoft.com/?kbid=247527

Hope that helps.

Sanchan [MSFT]

sanchans@online.microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.