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.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

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

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

Postby james.billings » Mon Feb 21, 2011 5: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests