I'm having almost the same error as this post:
http://www.red-gate.com/messageboard/viewtopic.php?p=43223&sid=2272a2786f47b8a076b955eb6f464af4
But my problem is with the method CONTAINS using the LANGUAGE keyword.
Here's a part of my query:
SELECT @CountRetailer = COUNT(*)
FROM RetailerSearchView ret
WHERE ret.IsActive = 1
AND
(
@RetailerCategoryId = 0 OR
ret.PrimaryCategoryId = @RetailerCategoryId OR
ret.SecondaryCategory1Id = @RetailerCategoryId OR
ret.SecondaryCategory2Id = @RetailerCategoryId
)
AND CONTAINS(*, @SearchCondition, LANGUAGE @Language)
and your parser seems to dislike the LANGUAGE @Language part of the CONTAINS method.
But my problem is with the method CONTAINS using the LANGUAGE keyword.
Here's a part of my query:
SELECT @CountRetailer = COUNT(*)
FROM RetailerSearchView ret
WHERE ret.IsActive = 1
AND
(
@RetailerCategoryId = 0 OR
ret.PrimaryCategoryId = @RetailerCategoryId OR
ret.SecondaryCategory1Id = @RetailerCategoryId OR
ret.SecondaryCategory2Id = @RetailerCategoryId
)
AND CONTAINS(*, @SearchCondition, LANGUAGE @Language)
and your parser seems to dislike the LANGUAGE @Language part of the CONTAINS method.