Is the following approach safe?

Export the public half of the certificate chain using the root CA certificate via MMC (Windows Certificate Manager

1. Open mmc.exe → File → Add/Remove Snap-in →...

We performed in-place upgrades of our SQL Server 2016 instances to 2022, and then patched to the latest build and are continuing to keep up-to-date. We are currently running the...

UPDATE: We had missed off "@use_databasemail=1" in our calling of this stored procedure. It always worked for us in the past, so perhaps @use_databasemail no longer defaults to "1" in...

That worked... by why? (thank you!)

You can see from the "01.jpg" screenshot that the mail profile had already been configured under the Alert System of the SQL Server Agent properties....

Appreciate this is an old post, but how does it work if tempdb is encrypted with one certificate but user databases are encrypted with different certificates?

Thank you, have you managed to get past the performance issues as a result of the version upgrade? Do you possibly have any links you can share on why this...

Thank you for your responses. We will look into the suggestions posted above to see if there is a way to recode this, and will come back to you.

Jonathan AC Reports - is HOLDLOCK not equivalent to the highest isolation level of SERIALIZABLE?

https://bobpusateri.com/2023/08/holdlock-serializable/

Fair point on the ROLLBACK, although it would close the BEGIN TRANSACTION (rather than leaving it open). @ReferenceNumber is used lower down.

SELECT @ReferenceNumber = ISNULL(@ReferenceNoPrefix, N'') +...

I am pleased to confirm that the solution provided by Jeffrey Williams has solved the issue for us. The modified code has been live for a few days now, and...

Thank you all very much for your suggestions. We are reviewing this to see how best to proceed. Will provide feedback on how this progresses.

@ScottPletcher - correct, no missing indexes were identified. Only the second query returned results.

Thanks all. I can confirm that the code is not being called in a loop, or in an explicit transaction. The parent procedure sproc_ValidateUser just performs some basic...

Removing duplicate comment. See below.

• This reply was modified 1 year, 10 months ago by zoggling.
• This reply was modified 1 year, 10 months ago by zoggling.

@ScottPletcher - apologies for the delay in responding to your post. Please find the requested results of running your script attached. Please let me know what you think, thank you.