Do you need to convert the dates ?  Isn't this OK ?

INSERT INTO homes.Properties
VALUES
(1, 1, '12a, Station Street, Liverpool', 500, '2019-12-31' )
,(2, 1, '12c, Station Street, Liverpool',...

• This reply was modified 1 year, 7 months ago by  homebrew01.

You may get better replies if you show what you have tried already, and what part is causing problems.

Expecting the entire solution from scratch seems a bit much.

I'm pretty sure that BCP doesn't work on actual spreadsheets ((but...

• This reply was modified 1 year, 7 months ago by  homebrew01.

Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.

• This reply was modified 1 year, 7 months ago by  homebrew01.

You can script your PROD MyTable table as CREATE to a SQL window, change the table name to MyTable_Stage, and change all the data types to VARCHAR(nn) , then run...

• This reply was modified 1 year, 7 months ago by  homebrew01.
• This reply was modified 1 year, 7 months ago by  homebrew01.

Go to DB Properties. What is the last log backup date ?

I just changed a FULL DB to SIMPLE and it  still shows the last Log backup date after I ...

• This reply was modified 1 year, 7 months ago by  homebrew01.

When I have similar problems, I make a staging table with the same fields as production, but all defined as appropriate length VARCHAR to eliminate (or reduce) data mapping errors....

• This reply was modified 1 year, 7 months ago by  homebrew01.

Thanks for the comprehensive reply.

It appears Datto also runs "DIFFs" during the day, but they also show as type 'D' in the SQL backupset table, not 'I' , and do not impact the native...

• This reply was modified 1 year, 8 months ago by  homebrew01.

"... ORDER BY 3 ..."

I recommend against this. Name the field.

If a new field gets added as 3rd field, you will get different results.

And, nobody knows what field '3' is,...

• This reply was modified 1 year, 9 months ago by  homebrew01.

Are these tables already being used ?

If so, Identify the "trouble areas" and look at how to fix them, rather than just build indexes you think might be needed.

Sounds like he doesn't deserve the help.

Why would someone do that ?

I reported that bug in May 2022. I guess...

Yes, those DO send the email.

Maybe I misunderstood the functionality, and "Run a Program " activates only...

• This reply was modified 1 year, 10 months ago by  homebrew01.
• This reply was modified 1 year, 10 months ago by  homebrew01.