Hello. I got the same problem. If I set Agent XPs to enable and try to start the service the system sets Agent XPs back to disabled. I have never...

Yes it is a good product. We use it in production on several SQL servers. But in this case, when we should totally move...

Something like this i think. Tablename is test with columns name, title and date:

<?xml version="1.0" ?>

<Schema xmlns="urn:schemas-microsoft-com:xml-data"

        xmlns:dt="urn:schemas-microsoft-com:xml:datatypes" 

        xmlns:sql="urn:schemas-microsoft-com:xml-sql" >

   <ElementType name="name" dt:type="string" />

   <ElementType name="title" dt:type="string"...

I have used this script many times and it works good. (I think I found it here on sqlservercentral).

/Joel

SET NOCOUNT ON

   DECLARE @LogicalFileName sysname,

           @MaxMinutes INT,

           @NewSize INT

   -- *** MAKE SURE...

As Guy say, you don't need VB on the computer. Just make an *.vbs file and windows execute it. Exampel:

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString = "provider=SQLOLEDB.1;data source=Servername;database=test;Integrated Security=sspi"

objBL.ErrorLogFile = "e:\temp\error.log"

objBL.Execute "e:\temp\schema.xml", "e:\temp\test.xml"

Set...

I have used the xmlbulkload function with a VB script to import xml to SQL. I think I saw a KB article at Microsoft about it. Look there.

The problem was that I didn't have anything in the backupdevice. But I still got the databasefiles. So restore is not possible. I have no backup on the...

Ok, thanks. Know I have some hour to handle this manualy instead 🙂

Have a good weekend.

/Joel