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.

I'll disagree.

Port scanners can be blocked, especially simple ones. Are there targeted, distributed scanners that use lots of IPs over time? Sure, but those aren't necessarily what many...

Frosty morning today, foggy and chilly. Need to ride a motorcycle home today for my kid (he's buying one). Gonna have to dig out some cold weather gear.

I would say your mileage may vary. This might help, it might not. It really depends on the IOPS and latency you are getting from your tempdb drive.

Lots...

What's in the execute_as_principal_id column in the sys.sql_modules DMV?

Execute as self is supposed to be execute as user_name, with the user ID being who created the proc.

This is based on the underlying Windows host policy. You need to check the security settings there.