When opening a SQL Server table in DataSheet View from an ADP file, the following error message might appear:

"The stored procedure executed successfully but did not return records."

This problem is likely to be caused by an invalid SQL statement stored in an Extended SQL Server property called MS_RowSource assigned to the column of one of the tables in the project. This property can be viewed, edited or removed by the SQL Query Analyzer. For more information see MSDN article "Extended Properties in SQL Server 2000" by Mike Gunderloy at:

http://msdn.microsoft.com/library/en-us/dnsqlpro02/html/sql02a10.asp

See also:

"Using Extended Properties on Database Objects"
http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_08_7qb7.asp

"Using SQL Server 2000 Extended Properties"
http://developer.com/db/article.php/10920_3361751_2