Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL MGMT Studio Export Reg Servers error

Author  Topic 

scottpt
Posting Yak Master

186 Posts

Posted - 2006-09-15 : 09:19:42
I am trying to write a script that creates the xml to import into Mgmt Studio. her is the error.

********************************************************************
'.', hexadecimal value 0x00, is an invalid character. Line 2, position 1. (System.Xml)

------------------------------
Program Location:

at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlReader.MoveToContent()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ImportForm.ValidateDialogForImport()
********************************************************************


Here is the top 3 lined from the export
------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Export serverType="8c91a03d-f9b4-46c0-a305-b5dcc79ff907">
<ServerType id="8c91a03d-f9b4-46c0-a305-b5dcc79ff907" name="Database Engine">


Here are the top 3 lines from my script
--------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Export serverType="8c91a03d-f9b4-46c0-a305-b5dcc79ff907">
<ServerType id="8c91a03d-f9b4-46c0-a305-b5dcc79ff907" name="Database Engine">

I cannot find anything on the web that documents how to create this file.


   

- Advertisement -