External Content Types Error Message
Using SharePoint Designer 2010, whiling trying to create a new External Content Types, I got the following error message while trying to expand the Tables/Views under the database:
"Can't complete refresh"
"Skipping the following table because it is not configured for use"
"Line 1: Incorrect syntax near '('".
The Routines folder expands fine.
It seems this error is due to the "unofficial" compatibility issue between SQL 2000 server and SharPoint 2010.