Nice question. Pity there was no reference in the explanation to anything that supported the answer 12 rather than 14, but as it's shown up in the discussion I...

Sear

I think it's pretty ugly and boring.

loss

GilaMonster (7/29/2013)

---

L' Eomot Inversé (7/29/2013)

---

I think this is about the first time I've disagreed with Gail about anything. She's better at most SQL Server things than me, but...

I guess your point is that if you take Chris's code (or equivalently Jeff's suggestion)...

What sort of login did you create?

If you gave a windows login access to SQL Server, and have created a user for it in its default database, then...

So that if someone tries to drop or modify the underlying table (or tables) in such a way that it would affect the definition of the view their ALTER TABLE...

I think "dislike" is perhaps a better word than either of those. In the...

+1000.

XML would...

I answered this question yesterday (as often happens Monday's question was available on Sunday) and didn't see anything in it that needed comment, Then today here piles of...

Nice question.

We are getting quite a series of questions on TDE. It's good to have many questions on a topic and fairly close together, as it teaches much more...

duplicated comment deleted

I think that's a great editorial, because it asks real questions.

But... CMM is one of my pet hates. It is a terrible idea. It tells you nothing....

So if the string were xyz-1-2.3-2 what's the required answer?

2, because...