0
votes
1answer
193 views

How to Read XML and Generate SQL Insert for Call Data Records

I am trying to write a VB Script to read a XML file (downloaded daily) and insert the information into a MSSQL DB. The content of the XML is a list of CDRs (Call Data Records). I need to parse the ...
0
votes
3answers
428 views

Slow Inserts SQL Server 2005

I'm researching an issue with the following information: We had a logging table with about 90k records in it that had inserts taking several seconds(approximately 10 to 20s) in extreme cases. One of ...
2
votes
3answers
570 views

Retrieve MS SQL database or table structure in XML

Is there a way to export the database schema in well formed XML of a MS 2000 SQL Server. I'm looking for just the structure not the data and the more detailed the better. The XML may be used in a ...
0
votes
1answer
366 views

SQL XML to Unicode no encoding

I want to export a varchar(max) column (SQL 2005) to an xml UTF 8 using BCP out to a file. I tryed using the -w option for BCP but so far it encodes my special characters in strings like – ...