Thank you. The User and System Data Source tabs are empty, in both the 32-bit and 64-bit ODBC Data Source Administrators. Should they be?

Thank you for your reply.

As per the above and attached, we already have ODBC driver 17.10.4.1 and ODBC driver 18.2.2.1 installed. We don't understand the dependency that the SQL Server...

Fair point!

Is there something we could have done to make that sort of search more efficient? How could we have done this differently? We were trying to fault-find an intermittent...

Could well be...

I have created an Extended Event session to try to capture what's going on.

-- Create new Extended Event session.
CREATE EVENT SESSION [StatusChanges] ON SERVER 
ADD...

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

Uninstalling "Microsoft SQL Server 2012 Native Client" resolve this for us.

Prior to this, we had also uninstalled all versions of SSMS, after we found the article below.

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-2019-installation-error-an-error-occurred-for-a/ba-p/998033

Doing the above resolved...

Thank you for your response. I am a local admin, and a domain admin also experienced the same issues.

What permissions is this needing? How can we find out what policy...

Thank you for your responses - some good suggestions there. We'll test these out and come back to you.

We had tried clustered indexes on ID previously, but they were not...

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

Yes we did that - the deadlocks were occurring between two SPIDs running the delete statement on the temporal table. The locked resource was the temporal table itself, with "IX"...

We attempted delaying each individual SPID by a random number of whole seconds, between 0 and 9. Even this didn't resolve the issue, with deadlocks continuing to occur as before.

Solution was found here:

https://dba.stackexchange.com/questions/63760/sql-server-audit-specification-filter-dml-by-all-but-one-user

Great, thanks!

SwePeso's solution at the following link has been the best help for this.

https://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145825

We created both of those keys (as they were not present), but no cigar sadly. Been Googling for most of the day!!

Thank you for your reply. Unfortunately I have been unable to locate the keys you reference (or any equivalents), throughout the whole registry?

Sue_H - the flags were definitely missing, we scripted the jobs out to check, and also stopped receiving job history information monitoring-side since the job steps were no longer logging...