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 |
|
iamgq2008
Starting Member
3 Posts |
 Posted - 2007-12-16 : 06:56:45
|
| Hi, I have run into a problem creating a full text catalog on a table which is using composite key as primary key. I am currently using SQL 2005 Std. Can someone please help? It's urgent! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 15:49:14
|
| What's the problem? |
 |
|
|
iamgq2008
Starting Member
3 Posts |
Posted - 2007-12-16 : 17:42:48
|
| If the table is using composite key as primay, it is not available for selection after you have created a full text catalog. Is there any way to get around the problem? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 17:59:12
|
| You mean can't select from those columns? Why? |
|
|
|
iamgq2008
Starting Member
3 Posts |
Posted - 2007-12-17 : 05:38:12
|
| After you have created a full text catalog, you suppose can select the table that are to be used in full text searching (I am using GUI for the process). However, if the table is using a composite key, the table will not be available in the list for selection. I can't even see the table. However, once I removed the composite key and only using one primary key, the table will be visible in the list for selection. It's simple process but I can't work out why. If you try it, you will know what i mean. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 13:16:21
|
| Did you try with select statement? Did you use ssms gui? What's your steps? |
|
|
|
|
|
|
full text catalog on table with composite key