I don't have time for a full answer, but the ACE driver is a separate install.

Take a look here: https://www.microsoft.com/en-us/download/details.aspx?id=54920

+1, me too.

Sounds like you will be interested in the Query Store.

Please take a look here: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

Here are some further ideas and suggestions for you:

1. Rather than using DEFAULT NULL, just define the column as NULLable.
2. There's no need for all those double quotes.
3. It's generally...

Did you...

To improve efficiency, I'd suggest you add columns to your data to track DateCreated and DataModified.

What is the reason for using XML in the data transfer?

Why do you want to...

That's true, Phil... but I don't keep the results of Dynamic SQL in source control.  I don't keep the code that gets stored in cache that I interrogate with...

• This reply was modified 3 years, 11 months ago by Phil Parkin.

It's algebra which could be directly calculated, no?

1555201/2^x=800

2^x=1555201/800

log10(2^x)=log10(1555201/800)

x = log10(1555201/800) / log10(2)

x=10.92481343

The number of times it would need to be "applied" before it crossed the 800 barrier would be...

Presumably you have...

Is this a SQL Agent job, or something else?

May I ask why you are doing this? There are other tried & tested ways of generating DDL.

Phil - that helps limit each printout to 4,000 characters but in my case the string is 11,698 so it breaks it into three separate lines. The script I'm...

Here is one way.

DECLARE @x TABLE
(
    FileName VARCHAR(50) NOT NULL
   ,CreatedDate DATE NOT NULL
   ,FileSendingDate DATE NOT NULL
  ...

Is this the final version, or are you going to continue gradually drip-feeding additional requirements?

If so, please skip to the end and provide the final version now, to avoid wasting...

Here is a chunk of code I've used in the past that may help you, where @SQL1 was previously declared as NVARCHAR(MAX).

    DECLARE @CurrentEnd...