Thom, the issue you are talking about appears to be what I reported 19 months ago:

https://www.sqlservercentral.com/forums/topic/major-issue-to-fix-asap-data-loss-for-characters-not-included-in-code-page-1252-2

My guess is that the data is using NVARCHAR as the datatype (based...

This issue was cross-posted to Ask.SSC:

https://ask.sqlservercentral.com/answers/156802/view.html

Based on the discussion there, this appears to be an issue with the IBM assembly attempting to get the directory name of where...

Just FYI, the forum post in question is:

https://www.sqlservercentral.com/forums/topic/issue-with-mssql-2017-clr-referencing-ibm-mq-amqmdnetstd-dll-3

Take care, Solomon..

Hi John. I did see your post on Ask.SSC and was about to post something there.

Regarding posting the question here in the "SQLCLR" forum/topic vs the "SQL Server 2017 -...

Hi there. I will do my best to answer your questions individually:

I was also thinking to build the logic such a way that it can be even triggered from...

• This reply was modified 4 years, 2 months ago by  Solomon Rutzky.

{ obsolete (but can't delete) }

• This reply was modified 4 years, 2 months ago by  Solomon Rutzky.

• This reply was modified 4 years, 3 months ago by  Solomon Rutzky.

You're welcome. And yes, that's what I've been told as...

It might have something to do with me editing it since it was migrated over here from the old site. Not sure if the others have been updated, or if...

It is noted as backwards compatibility and not ISO standard, but not deprecated. GROUP BY ALL is specifically deprecated, but if you have a reference, I'd be interested to...

• This reply was modified 4 years, 4 months ago by  Solomon Rutzky.
• This reply was modified 4 years, 4 months ago by  Solomon Rutzky.

Thanks for the notes. I'll update the question, but I don't see GROUP BY xxx WITH CUBE|ROLLUP deprecated. It is noted as backwards compatibility and not ISO standard, but...

Hi Steve. I think this is a good and interesting question, though I noticed a few issues:

1. The GROUP BY expr WITH xxxx syntax  is deprecated and shouldn't be used...

• This reply was modified 4 years, 4 months ago by  Solomon Rutzky.

True, there have been significant changes to the SQL Server installer over the...

As I said this thread is 10 years old

most people, whether ignorant or lazy, seem to rely on the installer choosing the correct collation.

it is important to set the...

Exactly! And fortunately, these threads don't stop accepting new posts, hence misleading statements can be clarified / corrected so new readers finding this thread...