>>>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

Could it be a synonym? See http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/51c6448b-9f03-4ebb-ab5e-6c0eba61215f