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.

Steve testing notifications of Rob's post testing notifications.

Another test to subscribe.

If there are simple queries, and it's a bulk set of data, I'd use bcp to pull out the data and then push it back in.

I think it's going to take some time to get used to the new look. I admit that some of the things bother me, but it's more that the interface,...