I am trying to import an XML document in SQL server using OPENXML. I need to retain my carriage returns and line feeds but they seem to get lost. I have tried using xml:space="preserve" but it didn't work. Any has any clue what needs to be done?
I would try seeking out some people more familiar with SQL Server and/or OpenXML (e.g. a Microsoft mailing list or discussion forum) because it sounds like an implementation issue.