Regarding the answer above, the Join discussion on mentioned page is going to this discussion thread.

Steve, Now you are the Sql person of the year (read it somewhere yesterday), congratulations...

Ok, this is showing the Primary key columns correctly:

SELECT DISTINCT

t.name AS Table_Nme, ept.value AS Table_Desc, c.name AS Column_Nme,

st.name + '(' + CASE WHEN c.max_length = -...

You get a 5 star rate from me.. This was just what I was looking for. We just made our database 100% documented, which on the buildserver for deploy builds...

I see you advicing against using Visual Interdev, my company is just looking for some vss integration for sql server. Why do you advice against it? (Thnx, i...