Strange error. I am setting up dataset by dragging and dropping tables and views from server explorer. Only problem is I cannot access views on the database. The error I get is
"Failed to retrieve data for this request. An exception occurred while executing a Transact-SQL statement or batch. Line 8: Incorrect syntax near '1'".
Thinking there may be a dodgy view on the database (SQL 2003) I have tried using a copy of the database and deleting all views bar the system views. Still the same error.

Can anyone help please?