This has been updated

Thanks for the warning Phil.

I remember now coming across that problem before and having to change the registry to disable the Jet driver from guessing based on the first...

Thats worked.

OK, you got me thinking about this; I have scripted the input file from the GUI (export definition), and I got this;

<?xml version="1.0" encoding="utf-16"?>

<DTAXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/dta">

<DTAInput>

...

Hi, from 2012, as well as 'File' and 'Table' there is a new 'Plan Cache' option, (which will take the top 1000 queries from the plan cache based on execution...

Thanks Sean,

CREATE TABLE [dbo].[Tree](

[Parent] [nchar](10) NULL,

[Child] [nchar](10) NULL)

CREATE TABLE [dbo].[Status](

[Node] [nchar](10) NULL,

[Enabled] [nchar](10) NULL)

--Insert values

insert into Tree values('A','B')

insert into Tree values('B','C')

insert into Tree values('B','D')

insert into Status values ('A','Yes')

insert into Status...

Yes, this should only affect your local PC.

This service allows programs to backup SQL databases, running on the local machine, without stopping the database engine. So if there are...

Hi Igor,

We need to see when the problem appeared and more background, is it a misconfiguration, or a result of bad code being sent to the server, this could be...

Of course it depends if any of your applications have dependencies on this. Generally, if you know what databases need backing up, you can always schedule a job for...