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 |
|
alexjamesbrown
Starting Member
48 Posts |
 Posted - 2007-05-05 : 10:20:39
|
| Hi there,I run this SQL against my database on my web host:EXEC sp_fulltext_catalog 'DescriptionsOfProducts', 'create'EXEC sp_fulltext_table 'tblProducts', 'create', 'DescriptionsOfProducts', 'PK__tblProducts__50FB042B'EXEC sp_fulltext_column 'tblProducts','ProductName','add'EXEC sp_fulltext_column 'tblProducts','ProductDescription','add'EXEC sp_fulltext_table 'tblProducts','activate'EXEC sp_fulltext_catalog 'DescriptionsOfProducts', 'start_full'---------------------------------It creates the catalog, without error and appears to populate it.however, when i look in the full text catalog properties, it has an item count of 0!!if i run the same code against my local machine, it works perfectly.any idea whats going on?!Alex |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 12:44:14
|
| What's ms index service account on the server? Does it have sysadmin rights? |
 |
|
|
alexjamesbrown
Starting Member
48 Posts |
Posted - 2007-05-05 : 15:21:34
|
| no idea,its hosted with fasthosts hosting company |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 18:13:17
|
| Check with them. |
|
|
|
alexjamesbrown
Starting Member
48 Posts |
Posted - 2007-05-05 : 23:21:44
|
| i have, but they say theres nothing wrong and its outside their support scope. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 23:51:10
|
| Possible to set it in em? Did you see sql login 'nt authority\system' on that server? |
|
|
|
|
|
|
|
|
Fulltext problem...