There is no default, and a blank is not allowed in recent versions of SQL Server without someone checking a box to say they want one.

If you connect as a...

Doing that now 🙂

Great player, HOF worthy for his accomplishments over time (3K hits, games played, All stars, 5 gold gloves, WS MVP, Rookie of the year, etc. He's had clutch hits, including...

FYI, since some of you submit questions. I'm no longer accepting images of code.

Please feel free to debate me.

Just a guess, but has the instance been restarted? It sounds like you've done things right, but perhaps something is stuck?

And another milestone for Jeter

http://www.nytimes.com/2012/08/03/sports/baseball/another-landmark-for-derek-jeter.html?smid=fb-share

Definitely use the upgrade advisor. Watch out for older scripts that check system tables as many of them have changed.

I assume you are doing a test upgrade, but please make...

Added my note to the SQLSat thread.

I'd like to do more, but with 6 SQL in the City dates + Connections, rather booked up for a few months.

Not me, though I'd like to. Camping with the family, so I'll be gone Mon/Tue as well (everyone behave).

My 2012 SQL Saturday schedule moving forward is likely:

Sept 22 - Denver

Oct...

That looks better. It's what you want in a trigger, a way to handle multiple rows.

I've edited the question down since I think it was a good question. I didn't catch the typo (grrr, no more images).

I'll award points back.

In that case, you could grant permissions to the login to get to the DMVs, but I wouldn't leave them there permanently.

The permissions are those of the user executing the code, so whoever updates the table has their permissions used.

I doubt most users have access to sys.dm_exec_connections. I would suggest you...

Interesting thoughts from Craig, and I like them overall. However if you go with 2 lower priced people to handle the duties, may I suggest you grab a consultant on...

SQLRNNR (8/2/2012)

---

Steve Jones - SSC Editor (8/2/2012)

---

Just a quick reminder here to everyone. This is a public forum, so the things you post are tied to you and available for...