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....

I'd try to recreate this with a few users and separate windows. To verify the issue. It might be a problem with the security module. I'll try to test in...

Not a great game. Now I can just hope the Steelers show up and beat the Pats next weekend.