SQL Source Control can't parse my script, SqlServer 2008 do

[Cactus]

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.

[james.billings]

Thanks for your post.

Which version are you using? I've tried replicating the issue here on a similar script and it seems to work; however I'm using a version 2 EAP.