+1 to what Grant wrote. It's the best advice I could give.

Are there any strange characters or anything else in the script? What if you open the script in Wordpad and then paste half of it in SSMS? Does it still...

I have no idea and can't see anything on this posted. If this is a production server, call Microsoft support.

Read this: https://www.sqlservercentral.com/articles/understanding-the-merge-dml-statement-in-sql-server-2008

And then this: https://www.sqlservercentral.com/articles/performance-of-the-sql-merge-vs-insertupdate

Please report to the webmaster (webmaster@ this domain) . Likely this is something easy to track but a report will get this routed to technical staff.

Styling and pasting are still being worked on. There are lots of interactions between the "rules" of how to interpret pasting and then the precedence of those.

Smart quotes and left/right...

🙂

As far as Integrated Authorization goes, how do you detect that? How can do determine that a user is trying to access tables within a SQL Server database using...

This might be the key

Yeah, it's time. We've debated about the thread name taking you there, but that's not what many people want. Plenty see something and want to read through the thread. The...

Noticed this. It's on the list

Let's try code

Select something

From somewhere

Where avalue = 10

More text

Yep, Redgate is closed Fri/Mon, so what gets done tomorrow will be it for the weekend. I'm out Friday, so I'll post status tomorrow and then we'll move next week,...

Woot! Rockies won three in a row. Still in the cellar, but making progress.

This last column seems wrong, however:

From here: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms186345(v=sql.110)

Need db_owner.