What is the error you receive when you click the "connect" button?

Developer does not have a 2 node limitation.

I'm curious about what blew up with TDE?

I don't know who maintains this list, but it is always up to date.

https://sqlserverbuilds.blogspot.com/

This link will get you going

https://www.sqlservercentral.com/blogs/how-can-i-configure-sql-server-to-listen-on-multiple-tcpip-ports

Michael:

Thank you for the suggestion, but unfortunately this brings back all jobs that failed regardless of the date, so it will show the last time a job failed, even...

This is the issue

AND h.run_date = (SELECT MAX(hi.run_date) FROM MSDB.dbo.SysJobHistory hi WHERE h.job_id = hi.job_id)AND h.run_status = 0 -- Only Failed Jobs

The run_status needs to go into...

Did the trigger not fire, or did the code not execute?

To test if a single column was updated, use the function UPDATE()

https://docs.microsoft.com/en-us/sql/t-sql/functions/update-trigger-functions-transact-sql?view=sql-server-ver15

Then, if true, use the values of inserted...

I'm not sure what...

You need to incorporate the virtual tables "inserted" and "deleted" into you query.

Also, when you update the "start" column, why can't you also add code to set the the columns?

Where have you heard this piece of misinformation???  A table can certainly have more than one...

Thanks for getting back,

I have this SP that runs on a reporting services application where the DB used to be Backup and restore.

Although it has a bunch of select...

What specifically is your issue?

NOTA.  None of the above

Some days I want to be the "Data Nazi", just like the soup nazi on Seinfeld. "No data for you!"

It's...