Problems Creating Full Text Index

Hi all,

Im new to sql and very interreseted in the Full text features, however when im trying to execute the following query:

USE Updater

CREATE FULLTEXT INDEX ON dbo.Servers (ServerName)

KEY INDEX ServerID

ON UpdaterCatalog

WITH CHANGE_TRACKING AUTO

GO

Where ServerID = Int NOT NULL IDENTITY and ServerName = VarChar(255) NOT NULL and UpdaterCatalog is just created

I get the following error:


Msg 7653, Level 16, State 1, Line 3

'ServerID' is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, and has maximum size of 900 bytes. Choose another index for the full-text key.


I cant seem to figure out why this wont work since unless im mistaking, both fields are legal.

Note that creating an index on any other table doesn't work either.

Im running Sql server standard edition (32 bits) on VISTA Ultimate X64

Thanks in advance,

Koen