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
Hilary Cotter - 24 Sep 2004 03:25 GMT
do this
alter table TableName
add intcol int not null identity(1,1)
go
create unique index TableNameUniqueIndex on TableName(intcol)

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
> hi,
>
[quoted text clipped - 8 lines]
> regards,
> Yukino