You may find the metadata is different for databases originally created in SQL 2000, 2005 or 2008 and not converted.
>>>>>I'm creating a SqlDataSource class in VS 2008 pulling from Northwind.
>>>>>
>>>>>When you get to the Configure the Select Statement pane, I selected the Products table. The Select statement is showing up
>>>>>as
>>>>>
>>>>>
SELECT * FROM [Alphabetical list of products]
>>>>>
>>>>>Where is this table description in SQL? I don't see it in Table->Properties
>>>>
>>>>Right click on the table, Properties, Entended Properties.
>>>
>>>I did already. It's not there
>>
>>I checked AdventureWorks database and it was there. Though it's a description
>>
>>Employee information such as salary, department, and title.
>I also see it for AdventureWorks. But I don't see any descriptions in Northwind. They must be there becuase VS2008 shows it
>as well as the SQL Server Table Dependancies dialog.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
