When I open the file in Toad for SQL 5.7, I get the attached error. (See below.)
When I copy and paste from SQL Server into Toad for SQL Server, it deletes the special character.
System.Xml.XmlException
' ', hexadecimal value 0x01, is an invalid character. Line 30559, position 37.
Stack Trace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, BufferBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRef(Boolean expand, BufferBuilder internalSubsetBuilder, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.HandleEntityReference(Boolean isInAttributeValue, EntityExpandType expandType, Int32& charRefEndPos)
at System.Xml.XmlTextReaderImpl.ParseAttributeValueSlow(Int32 curPos, Char quoteChar, NodeData attr)
at System.Xml.XmlTextReaderImpl.ParseAttributes()
at System.Xml.XmlTextReaderImpl.ParseElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlReader.ReadToDescendant(String name)
at Quest.Toad.Editor.Parsers.SqlParser.DeepParseXml(List`1 nodes, NavigatorNode parentNode, ChunkTypes chunkType, String xml)
at Quest.Toad.Editor.Parsers.SqlParser.Parse(String text, Boolean checkSyntax)
at Quest.Toad.Editor.EditorForm.Parse(Boolean processParserMessages, Boolean syntaxCheck)
at Quest.Toad.Editor.EditorForm.Parse(Boolean processParserMessages)
at Quest.Toad.Editor.EditorForm.Parse()
at Quest.Toad.Editor.EditorForm.DoFileOpen(String file)
at Quest
WORKAROUND 1:
Use Toad for SQL Server version 5.6
WORKAROUND 2:
Try to find a replacement for the symbol leading that is generating the error.
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
