Hi,
I'm currently trying to export a single column of data to a text file, I'm having difficulties as the text length is a varchar(2000) and contains '>' and '<'. I've tried outputting via xp_cmdshell but I think I have problems as the cmd length ends up greater than 255, I've tried iSQL to a text file but only get the first 255 characters and have tried a datapump export but again only get the first 255 characters. Are there any setting to remove this limit on the latter two solutions or is there a better method to accomplish this
Im using SQL Server 2000.
Any ideas greatly appreciated.
Thank you,