Polling is probably the best solution but you might also be able to Powershell (.Net) to start a SQL process with event tracing:

https://mcpmag.com/articles/2019/05/01/monitor-windows-folder-for-new-files.aspx

We have a few old third party systems that use...

While not really a problem, it does look at bit odd when tblNameOfTable turns out to be a view.

https://sqlquantumleap.com/2017/12/30/please-please-please-stop-using-impersonation-execute-as/

https://www.sommarskog.se/grantperm.html

Start by looking at the output in a better editor like notepad++ or VS Code.

This is a delayed message as I was...

I do not think this type of problem is solvable with windowed functions as the result is dependent on previous values in the series. In this case I cannot see...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.

running a vendor supplied application which couldn't run on a newer version.  Still waiting on the vendor for 18 of those servers to supply the fix they promised in...

https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver16

The simplest approach would be to make the user the owner of the job and add them to the SQLAgentUserRole. Of course this will allow them to create, modify and...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.

The following suggests it is just another change in the default value:

https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace?view=sql-server-ver16#encrypt-default-value-set-to-true

You need to make sure you do not rely on the defaults for your connection. ie Explicitly set...

As mentioned it is only a different default for the latest version of ADS. As I presume you do not use CA certificates on your servers it is easy enough...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.

Only you can say what else is likely to interact with...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.
• This reply was modified 2 years, 9 months ago by Ken McKelvey.
• This reply was modified 2 years, 9 months ago by Ken McKelvey.

To get a reasonable answer you are going to have to post DDL, consumable test data and the expected result.

>> But the merge statement takes all transactions as a single...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.

I do not think this is a big deal either way. If the server has a self-signed certificate then just alter the connection to trust it. This just means the...