sqlsni.trace seems to be removed in CU8 probably for fix 13671396 XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019.

Thanks to stummsft for a helper function

Solved: On SQL2019 it's called sqlsni.sni_trace instead of sqlsni.trace

Test before you try this

Now it is more clear (misread domainy). You want to change the domain of the client and make sure the acces to the original sql servers...

Can you elaborate a bit?

There is a windows client domainx\userA on client Z on domainx

That has acces to server 1,2,3,4,5,6,7

Question:

If i move the user from client Z to client W,...

Happy New Year 2021

Had to lookup up what you meant with "magic tables". Are those the inserted / deleted tables you can reference from triggers or the output clause?

What is magic table in...

For TLS 1.2 you'll need version 11.0.6216.27 https://support.microsoft.com/en-us/help/3135244/kb3135244-tls-1-2-support-for-microsoft-sql-server

Might als wel update to SP4 + CU + security fix https://sqlserverbuilds.blogspot.com/#sql2014x.

Can't verify it because our servers are 2017+

What is the patchversion of SQL Server 2014 ? It could be that TLS 1.2 is now required

Can we upgrade straight to CU15 for CU12: yes . CU's contains the patches since SP2

SSMS: check releasenotes https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15

Have it as a text parameter instead of datetime? Use a second internal parameter to convert the text to datetime?

Thanks for the feedback

Is max memory for the sql server instance set to lower than  839GB, so other applications like the operating system can run?

Is SSAS installed on the server? There was a...

Happy thanksgiving. Hopefully next year in different circumstances

You might want to try out table/index pagecompression to reduce the size

There are no more servicepacks since SQL 2017 as part of the cloudfirst strategy. Currently at update 22. https://sqlserverbuilds.blogspot.com/

*edit* You might consider SQL Server 2019 is your project is still...

• This reply was modified 5 years, 4 months ago by Jo Pattyn.