I have a problem in full population for a full text index.
When I run the population; these are the results
- Population duration : 3-5 seconds.
- item count : 0
- catalog size : 0
- unique key count : 1
although I have 7 million of records in that table
I need explanation please.
Than you
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
can you look in the application log for event messages from MSSearch or
MSSCI?
Most often this problem is caused by
1) changing the SQL Server service account through control panel instead of
Enterprise Manager
2) changing MSSearch's service account to a local or domain account instead
of keeping in local system
3) removing the builtin\administrators group from the system administrators
role.
to fix 1 refer to
http://support.microsoft.com/default...b;en-us;277549
to fix 2 click Start, point to settings, click control panel, double click
administrative tools, double click on services, double click Microsoft
Search, click the Logon tab, and select Local System, clear the Allow the
service to interact with the desktop, click on Apply and ok, and accept all
defaults
to fix 3 execute the below tsql in Query Analyzer
--Grant [NT Authority\System] a logon to SQL Server:
EXEC sp_grantlogin [NT Authority\System]
--Add that account to the sysadmins role:
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System] , @.rolename =
'sysadmin'
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mohamed Salah" <msalah_din@.yahoo.com> wrote in message
news:u5Ls8eicEHA.3944@.tk2msftngp13.phx.gbl...
> I have a problem in full population for a full text index.
> When I run the population; these are the results
> - Population duration : 3-5 seconds.
> - item count : 0
> - catalog size : 0
> - unique key count : 1
> although I have 7 million of records in that table
> I need explanation please.
> Than you
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||You did build the catalogue first and then try a full-text population?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment