I agree with Lynn. Use a DDL trigger here that will read metadata to build the changes needed for a table to replicate it.

What I'd do is create a process...

We think we've found something that might cause this to occur. I hope a fix will come out soon. Will post a note when I see the deployment.

Use IPSec at the network layer (or VPN tunneling).

Look at unpivot

https://www.sqlservercentral.com/articles/an-alternative-better-method-to-unpivot-sql-spackle

Great point, Ralph. Note that PowerShell and Python are also great text processing utilities as well. Learning some of the Unix, PoSh, or Python skills can be very handy for...

I'm not judging you, at least, I don't think I am. I'm really pointing out a reality that occurs often. Many people get complacent in their jobs, and they become...

We all think of speech, but text to AI works as well. I think things could work well, but we have so much ambiguity in communication, not sure that an...

Thanks

You don't need an insert, you need an update. However, your update needs to include a concatenation of the previous contents.

Something like:

create table #mytable(myid int, mycomment varchar(200))
insert...

Thanks for the votes. I'll note this in the ticket.

I would agree with Grant. This is a "for the job" question. You also leave out some of the factors with regard to price. For many applications, either works great....

Agree with Grant.This is a short sighted request  and isn't a requirement. What a requirement would be is to present the data in this way. The way to store this...

Closing. Visit the other thread for an answer.

Thanks for the effort. I've posted a bug and tagged it high priority. Everyone's out now, but we'll follow up tomorrow.

Below the "Your account" is the toolbar. This is supposed to be visible for everyone. If I log in with a test account, I see this for this thread: