I hate centralized systems. That creates a single point of failure that depends on lots of stuff (Security, networking, etc.) working correctly.

I do think PoSh works well for...

Thanks, that would be great.

Thanks,...

The points system changed slightly because we have new ways to award points based on answers and marking / liking posts. I had a list, but need a final one...

Most people just seem to assume if the server is up, things are working. This usually leads to constant fixes as still broken items are fixed on the fly. One...

I would follow David Burrows advice above. Join inserted to the original table in the trigger.

Thomas, take it.

Eric, there is no original article listed. I noted that it should be similar to a TDE article, any one. How to enable and then set...

If you're updating, then why not put the UPDATE in the trigger? Something like this:

ALTER TRIGGER [dbo].[tr_datediff] ON [dbo][JOURNAL]  FOR INSERT,UPDATE
AS
Update mytable
set mycol = DATEDIFF(d,start_date,end_date)[diff]

Are you sure this is SQL 2016 RTM media? Have you used it elsewhere to install?

I haven't tried upgrading a 2014 instance, and don't like in place upgrades....

If you are trying to get just those rows updated or deleted, use this:

ALTER TRIGGER [dbo].[tr_datediff]...
 

Morning commute:

In playing more, I found this article: https://support.microsoft.com/en-us/kb/913422
This article notes: For security considerations, the server-scoped permissions are stripped down when you impersonate a database user...

Yep, the "self" doesn't seem to work. I created two users, one with DBOwner, one with sysadmin. Both created a proc that calls Bulk INSERT with AS SELF. Neither works....