Pretty cool.

I too thought the default length was 30.

Not stating the collation setting makes it obvious no matter what actual db settings you work with regularly.

Thanks for the question and education.

EASY MONEY!!!

This time:-P.

Chris Stewart-397033 (7/15/2010)

---

Also in BOL under the CREATE TABLE entry is the following (partial) definition of IDENTITY (emphasis mine):

IDENTITY

Indicates that the new column is an identity column. When a...

Nice article. Thanks for the time and effort that you took to write it.

Nice story and extra stars for this...

Spend some time with your end users, if possible. Get to know them as people, not just users. Find out what they actually do,...

Hugo Kornelis (7/13/2010)

---

Tom Garth (7/13/2010)

---

I got it right for the wrong reason. I didn't notice the semi-colon, and since A. would not have been a complete answer, I chose C....

I got it right for the wrong reason. I didn't notice the semi-colon, and since A. would not have been a complete answer, I chose C. which amounted to "None...

Good question, and a good reminder. Thanks.

I think the answer is not quite correct. The action only changes the LEADING spaces on a line to tabs.

Wow! I can't believe some of the readers took this article so personally.

In my case you are preaching to the choir, and never the less produced a highly entertaining piece....

Very creative. I really like it.

SQL_Elvis (6/21/2010)

---

One benefit is that the Certificate and certificate user account are managed outside of the stored procedure code and can be updated or the user account changed without having...

I think there is some lack of the warm and fuzzy with the clients that we have, and I don't particularly have it either. Especially when it comes to financial,...

Jonathan AC Roberts (6/21/2010)

---

ChiragNS (6/21/2010)

---

We granted select permissions to mycertificateuser. Do we need to give permissions to all the other users who are going to execute the procedure (i think...