Sounds to me like you are trying to execute a stored procedure with the "WHERE" part as your input parameter...

exec stp_deliverystatus @customernumber = 263722

Full syntax:

USE [Galactic]

GO

DECLARE@return_value int

EXEC@return_value = [dbo].[stp_deliverystatus]

@customernumber =...

I also found this useful when querying a workbook with several worksheets:

EXECUTE SP_TABLES_EX 'your_linked_servername_goes_here'

which...

Please read this MS article: http://support.microsoft.com/kb/814398

I experienced this same error and the article helped solve the problem.