I've just imported everything in my XML file as varchar and then managed to convert some of the fields to Decimal(18,2) in SQL Server Management Studio however some apparently numeric...

OK but like I said it stops inserting before the first record and I presume it's to do with the characters in the field of the first row. I know...

Hi, I'd already checked the whole file and all are entered as integers. It stops inserting at the first record, at the "Length" element, which is "9".

Thanks for this however I have VS Express and creating an XML schema from an XML document is a feature not included.

Thanks that looks useful however there doesn't seem to be an option to import XML files?

It didn't matter what account I used in order to connect to SQL Server from Visual Studio. I've used an account to log in now and it was SQL Server...

Thanks but I'm still none the wiser. What do I select from here under SQL Server Configuration Manager?

There's no way to select the special accounts you mention. There's NETWORK and...

Thanks. Are you available for a fee to log in remotely and see if my installation can be saved or if you can figure out why it won't install? Don't...