What is supposed to happen to the 5 million rows in Table A AFTER you've copied them to Table B and is Table B on the same database and on...

I agree with David Poole.  To put it all in less formal terminology, I've found that tools like ChatGPT are nothing more than a very sophisticated consensus engine and, sadly...

So, are you leaving all of this up to us to contact @marketing, etc?

IMHO, true experts have enough knowledge about a particular subject to know when they don't know something about that subject and aren't afraid to say so.  Saying "I don't know"...

Lordy... even that response seems artificial, especially considering that the author supposed posted that response.  Doesn't pass the "Turing Test", IMHO.

I also expected to see some actual data in this...

Go to your first post above.

Click on your name.  That will take you to a different screen at the top level of your profile.

Click on "Edit Profile".

Follow your nose to...

I have to ask... are the middle two letters in the author name indicative of what wrote this article?

Interesting.  I've never using the SET OFFLINE...

Please obfuscate the database name and then post the exact command(s) you're using to do the restore.

Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.

More berries to come in a few weeks, possibly just as many.

What to...

Here's just one of the many proofs... Both the direct conversion from DATETIME2 to DATETIME and the faulty answer above produce the "silent failures" that I'm...

I thought I had a good one but then found a "silent...

Yes, well ChatGPT generates its responses one word at a time, using each preceding word and the context of the conversation, including its own partially completed sentences, to predict...

I haven't got Copilot, but I thought I'd try it on ChatGPT

Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉