i thought i responded to this already.  jeff i dont get what you are saying but a peer claims a synonym for the linked server name itself is forbidden. ...

Awesome!!!!!!!!!  Ed Wagner and I both have confirmed hotel reservations.  We'll be at the same...

I'm presenting so I could easily go either way for lunch but...

The OP has left the building!

That WAS a fun award party.  I still have the piece of real live rebar that they presented to me.  It was an awesome night.

The post brings back a memory...

How did you supposedly "learn" that they aren't allowed on linked servers?  I ask because I...

Heh... SQL Server 2017... the last and final version that had good speed.  They "Robo-Copped" 2019 and up with all sorts of "rules". 😉

(bumping the page 2 fault on this forum)

I used to be a front-end Developer... that's why I don't rebuild indexes all the time   ... The page splits that came after the rebuilds would slow down...

To be clear, I don't know how obvious or obscure the bug might be. It might be expected behavior to detect duplicate posts, though I'd expect it to say...

Hi Everyone, I have the data in the below form :

Desired output:

Here...

Team,

Please suggest or if you have an example please share the link for loading AML (anti moneylaundering)files into SQL Server. Meaning file having multiple recs in the .txt/.cvs file....

I thought this must be from years ago but only a few months. Maybe just the reply.  I've had the same discussions, or more like yelling matches with DBA...

You can create a 2 part synonym with the same table name as before that points to the linked server using 4 part naming.  Zero code changes will be required.

However,...

Wow.  I have to ask... what makes you think our complaints would be acted upon if...