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

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

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

Postby Cactus » Thu Feb 10, 2011 9:28 pm

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
@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.
Posts: 1
Joined: Thu Feb 10, 2011 9:23 pm

Postby james.billings » Mon Feb 21, 2011 4:59 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests