In Enterprise Search, you can only specify SCOPE() for the scope name. This is a change from Microsoft Office SharePoint Portal Server 2003 Search. In SharePoint Portal Server 2003 Search, you specified the scope name in the FROM clause, for example:

FROM Portal_Content..Scope() WHERE…

For Enterprise Search in Microsoft Office SharePoint Server 2007, you specify the scope name in the WHERE clause, as follows:

FROM Scope() WHERE "scope"='All Sites'…

Note:
The scope name is case-sensitive, and you must include double-quotation marks (") around scope.

For information about how to specify search scopes in a query, see "Specifying Search Scopes" in WHERE Clause in Enterprise Search SQL Syntax.

Other Resources