problem with create index -- sql server full text search

Hilary Cotter
9/23/2004 10:25:06 PM

do this

alter table TableName
add intcol int not null identity(1,1)
go
create unique index TableNameUniqueIndex on TableName(intcol)

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]

Yokino
9/24/2004 10:15:08 AM

hi,

I have problem with my current table design in implement the full-text
search.
Since the existing table doesn't have single unique field(my existing design
is composite key field, which means 2 field combine together as unique). how
to do create the index full-text search. The system is running in client
side. it will be risky if modify the table structure. Any sugguestion for
this problem? thanks.

regards,
Yukino

sql server full text search : problem with create index