SOX audit gunna eat them alive.

That trigger was placed there for a reason.

In financing terms once something is on a journal / ledger, it should ALWAYS remain on that journal / ledger.

If there was an...

Unable to open the physical file "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf"

SQL thinks it was installed to the D: location.

If you don't have a D: then you'll need to uninstall SQL and install it to...

You need to physically move the files from the old drive to the new drive.

SQL will not do this for you.

So when you have done the ALTER ... MODIFY, then...

Now what you could do is to write a proc which does it then ties it to a certificate which has the access.

This is similar to how you can give...

Permissions to the DMV's are detailed on their respective documentation page.

sys.database_principals

Permissions
Any user can see their own user name, the system users, and the fixed database roles. To...

Probably allows the use of old legacy ciphers / algorithms, but just clutching at straws there, unsure of the internals.

We can only go on what the public documentation says.

Might be...

You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

SELECT...

Are you sending via O365? SQL 2016 and below don't have DotNet set to use strong ciphers, and O365 says you need it.

There's a few things you need to change...

Check the database mail log and verify the email is being sent to the queue, the queue is active and that there are no errors.

select * from...

Use an older version instead unfortunately.

As per the documentation, 20.2 is only tested on 2014 and above.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#supported-sql-offerings

You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

SELECT * FROM...

Probably best you join the Slack community and post in the #dbatools channel

https://dbatools.io/slack

A lot of the DBATools folks hang out there instead.

So whats in the trace file?  Does it help us understand whats happening in some way?

sp_send_dbmail is not available on Azure SQL DB, so you will need to use some 3rd party application which can integrate with your application to send mail on it's behalf,...