Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2008-03-28 : 10:12:28
|
| hithis follwoing code is throwing an error in sql server 2005 CREATE FULLTEXT INDEX ON table_name [(column_name [TYPE COLUMN type_column_name] [LANGUAGE language_term] [,...n])] KEY INDEX index_name [ON fulltext_catalog_name] [WITH {CHANGE_TRACKING {MANUAL | AUTO | OFF [, NO POPULATION]}} ] the error is as follows :Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near 'FULLTEXT'. what is wrong with the syntax?thanks in advance |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-28 : 10:20:35
|
| wow! did you run that exactly as is?? did you copy it straight from books online? that is not the code you actually run it's just showing you how to lay it out with various options. look at the transact sql syntax conventions link in book online, and also look at the examples books Online shows you at the bottom of a pageEm |
 |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2008-03-28 : 10:27:53
|
| yes i copied it from online but atleast it should parse the query correctly if the syntax is right .it wont execute the query i know that. thanks for for your reply anyways |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-28 : 10:36:42
|
| i wouldn't expect it to parse. the [ ] would translate to column names etc, so it's just nonsense to the parser, no?Em |
|
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2008-03-28 : 10:47:00
|
| i figured it out i was trying to use sql server 2005 syntax against a server 2000 installation. may be i just overlooked. |
|
|
|
|
|
|
full textx error