After Full Population, ItemCount = 0

After full population on a table with 1 million rows:
Item Count: 0
Catalog size: 1 MB
Unique Key Count: 1
I used SQL Enterprise Wizard for Full-Text Indexing on a table with 1
million rows.
Obviously, Item Count should be greater than zero.
SQL Service is running on Local System account. I have SysAdmin privileges.
the 1 unique count refers to the table.
Please post any messages you may see in your event log from MSSearch or
MSSCi.
Can you follow the advise in these kb articles?
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;277549
http://support.microsoft.com/default...b;en-us;814035
"MGBloomfield" <MGBloomfield@.discussions.microsoft.com> wrote in message
news:B777D507-E501-44BA-AE29-91B3F1407675@.microsoft.com...
> After full population on a table with 1 million rows:
> Item Count: 0
> Catalog size: 1 MB
> Unique Key Count: 1
> I used SQL Enterprise Wizard for Full-Text Indexing on a table with 1
> million rows.
> Obviously, Item Count should be greater than zero.
> SQL Service is running on Local System account. I have SysAdmin
> privileges.
>
|||In this knowledge base article, Q317746
"PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
It's says to make sure that:
1) Make sure that the BUILTIN\Administrators login exists in SQL Server.
-and-
2) Make sure that the Microsoft Search service is running under the Local
System account.
As a resolution, it says:
1) Grant the [NT Authority\System] user a logon to SQL Server.
For example: EXEC sp_grantlogin [NT Authority\System]
2) Add that account to the sysadmins role:
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System], @.rolename =
'sysadmin'
I'm logged in using the sa account so this isn't the problem.
|||<b>http://support.microsoft.com/default...b;en-us;317746</b>
There are no errors when doing Full Population or Incremental Population.
<b>http://support.microsoft.com/default...b;en-us;277549</b>
There are no errors when doing Full Population or Incremental Population.
<b>http://support.microsoft.com/default...b;en-us;814035</b>
select fulltextcatalogproperty('northwind','itemcount')
Result: No rows returned
More insights:
1) Running SQL Server 2000. Fresh install. Not upgraded from SQL Server 7.0
2) There are no errors in the Event Application Log.
3) BUILTIN\Administrator is removed.
4) Connected using sa account.
5) Set up full-text indexing using the SQL Enterprise Full-Text Indexing...
wizard.
Other queries that I've tried:
<b>exec sp_help_fulltext_catalogs</b>
ftcatid NAME PATH
-- -- ----
5 Northwind D:\Program Files\Microsoft SQL Server\MSSQL\FTData
<b>exec sp_help_fulltext_tables</b>
TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME and so on...
-- -- --
dbo Categories PK_Categories
dbo Customers PK_Customers
dbo Employees PK_Employees
<b>exec sp_help_fulltext_columns</b>
Result: Several rows of columns that are indexed.
|||Can you examine the informational messages from MSSearch and MSSCi in the
application log - the messages will likely not be errors.
"MGBloomfield" <MGBloomfield@.discussions.microsoft.com> wrote in message
news:EDF955BC-86F2-44F2-A033-9FBE8F4BA065@.microsoft.com...
> <b>http://support.microsoft.com/default...b;en-us;317746</b>
> There are no errors when doing Full Population or Incremental Population.
> <b>http://support.microsoft.com/default...b;en-us;277549</b>
> There are no errors when doing Full Population or Incremental Population.
> <b>http://support.microsoft.com/default...b;en-us;814035</b>
> select fulltextcatalogproperty('northwind','itemcount')
> Result: No rows returned
> More insights:
> 1) Running SQL Server 2000. Fresh install. Not upgraded from SQL Server
> 7.0
> 2) There are no errors in the Event Application Log.
> 3) BUILTIN\Administrator is removed.
> 4) Connected using sa account.
> 5) Set up full-text indexing using the SQL Enterprise Full-Text
> Indexing...
> wizard.
> Other queries that I've tried:
> <b>exec sp_help_fulltext_catalogs</b>
> ftcatid NAME PATH
> -- -- ----
> 5 Northwind D:\Program Files\Microsoft SQL Server\MSSQL\FTData
> <b>exec sp_help_fulltext_tables</b>
> TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME and so on...
> -- -- --
> dbo Categories PK_Categories
> dbo Customers PK_Customers
> dbo Employees PK_Employees
> <b>exec sp_help_fulltext_columns</b>
> Result: Several rows of columns that are indexed.
>
|||A) Cleared the Event Application Log.
B) Ran the Full Population command.
C) Checked the Event Application Log.
Result:
1) No Information messages
2) No Error messages
3) No Warning messages
|||can you open a command prompt and navigate to C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\GatherLogs>
or
C:\Program Files\Microsoft SQL
Server\MSSQL$InstanceName\FTDATA\SQLServer\GatherL ogs>
zip up the contents you find there and either post them here or send them to
me offline.
"MGBloomfield" <MGBloomfield@.discussions.microsoft.com> wrote in message
news:C30E9BE9-25B8-4238-A3F1-A491A5C2C29C@.microsoft.com...
> A) Cleared the Event Application Log.
> B) Ran the Full Population command.
> C) Checked the Event Application Log.
> Result:
> 1) No Information messages
> 2) No Error messages
> 3) No Warning messages
>
|||the sa account has no bearing on whether the builtin\administrators role is
part of the system administrators role.
Please add it back in or follow the instructions in this kb article.
"MGBloomfield" <MGBloomfield@.discussions.microsoft.com> wrote in message
news:31616064-05D9-475A-8A76-6C63F5CF1CF9@.microsoft.com...
> In this knowledge base article, Q317746
> "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
> It's says to make sure that:
> 1) Make sure that the BUILTIN\Administrators login exists in SQL Server.
> -and-
> 2) Make sure that the Microsoft Search service is running under the Local
> System account.
> As a resolution, it says:
> 1) Grant the [NT Authority\System] user a logon to SQL Server.
> For example: EXEC sp_grantlogin [NT Authority\System]
> 2) Add that account to the sysadmins role:
> EXEC sp_addsrvrolemember @.loginame = [NT Authority\System], @.rolename =
> 'sysadmin'
> I'm logged in using the sa account so this isn't the problem.
>
|||I looked at the list of Server Roles. This is what we have.
Bulk Insert Administrators
Database Creators
Disk Administrators
Process Administrators
Security Administrators
Server Administrators
Setup Administrators
System Administrators
So, which role is the "BUILTIN\Administrator"? If it's System Administrator,
then it's already in there.
|||double click on the system administrator role. Is the BuiltIn\Administrators
group there?
"MGBloomfield" <MGBloomfield@.discussions.microsoft.com> wrote in message
news:49E74919-224A-4314-93B4-77EBA2395C18@.microsoft.com...
> I looked at the list of Server Roles. This is what we have.
> Bulk Insert Administrators
> Database Creators
> Disk Administrators
> Process Administrators
> Security Administrators
> Server Administrators
> Setup Administrators
> System Administrators
> So, which role is the "BUILTIN\Administrator"? If it's System
Administrator,
> then it's already in there.
>