Hi,
This Query :
SELECT 0
FROM
WOTransit -- with (index=x1,readuncommitted)
INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
WHERE WO.Cmd_No=814352
AND ISNULL(WOTransit.Charge_ref,0) <> 0
Since this morning this query is much more slow than usual
If i add : "with (index=x1,readuncommitted) ", the speed
is back to normal. because analyser usually use that
index.
If not, analyser is using a clustered index that is not
related to the query.
why doesn't he use the right index ?
What can i do to fix that ? i allready ran UPDATEUSAGE
and no change.
Thank you !
DonaldHave you rebuilt or defragged the x1 index?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald|||Yes,
i dropped X1 index and recreated it
>--Original Message--
>Have you rebuilt or defragged the x1 index?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
>> Hi,
>> This Query :
>> SELECT 0
>> FROM
>> WOTransit -- with (index=x1,readuncommitted)
>> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
>> WHERE WO.Cmd_No=814352
>> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>>
>> Since this morning this query is much more slow than
usual
>> If i add : "with (index=x1,readuncommitted) ", the speed
>> is back to normal. because analyser usually use that
>> index.
>> If not, analyser is using a clustered index that is not
>> related to the query.
>> why doesn't he use the right index ?
>> What can i do to fix that ? i allready ran UPDATEUSAGE
>> and no change.
>> Thank you !
>> Donald
>
>.
>|||This is what I usually do. Compare the actual plan and estimated plan
(without the hint). Look for areas where the number of rows differ greatly.
Try to understand why the estimate is way-off here. You might need to
update the statistics with the FULLSCAN option in order for SQL Server to
make better estimates.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
Showing posts with label index. Show all posts
Showing posts with label index. Show all posts
Thursday, March 22, 2012
Analyser no using right index
Hi,
This Query :
SELECT 0
FROM
WOTransit -- with (index=x1,readuncommitted)
INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
WHERE WO.Cmd_No=814352
AND ISNULL(WOTransit.Charge_ref,0) <> 0
Since this morning this query is much more slow than usual
If i add : "with (index=x1,readuncommitted) ", the speed
is back to normal. because analyser usually use that
index.
If not, analyser is using a clustered index that is not
related to the query.
why doesn't he use the right index ?
What can i do to fix that ? i allready ran UPDATEUSAGE
and no change.
Thank you !
DonaldHave you rebuilt or defragged the x1 index?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald|||Yes,
i dropped X1 index and recreated it
>--Original Message--
>Have you rebuilt or defragged the x1 index?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
usual[vbcol=seagreen]
>
>.
>|||This is what I usually do. Compare the actual plan and estimated plan
(without the hint). Look for areas where the number of rows differ greatly.
Try to understand why the estimate is way-off here. You might need to
update the statistics with the FULLSCAN option in order for SQL Server to
make better estimates.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
This Query :
SELECT 0
FROM
WOTransit -- with (index=x1,readuncommitted)
INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
WHERE WO.Cmd_No=814352
AND ISNULL(WOTransit.Charge_ref,0) <> 0
Since this morning this query is much more slow than usual
If i add : "with (index=x1,readuncommitted) ", the speed
is back to normal. because analyser usually use that
index.
If not, analyser is using a clustered index that is not
related to the query.
why doesn't he use the right index ?
What can i do to fix that ? i allready ran UPDATEUSAGE
and no change.
Thank you !
DonaldHave you rebuilt or defragged the x1 index?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald|||Yes,
i dropped X1 index and recreated it
>--Original Message--
>Have you rebuilt or defragged the x1 index?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
usual[vbcol=seagreen]
>
>.
>|||This is what I usually do. Compare the actual plan and estimated plan
(without the hint). Look for areas where the number of rows differ greatly.
Try to understand why the estimate is way-off here. You might need to
update the statistics with the FULLSCAN option in order for SQL Server to
make better estimates.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx
.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
Analyser no using right index
Hi,
This Query :
SELECT 0
FROM
WOTransit -- with (index=x1,readuncommitted)
INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
WHERE WO.Cmd_No=814352
AND ISNULL(WOTransit.Charge_ref,0) <> 0
Since this morning this query is much more slow than usual
If i add : "with (index=x1,readuncommitted) ", the speed
is back to normal. because analyser usually use that
index.
If not, analyser is using a clustered index that is not
related to the query.
why doesn't he use the right index ?
What can i do to fix that ? i allready ran UPDATEUSAGE
and no change.
Thank you !
Donald
Have you rebuilt or defragged the x1 index?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
|||Yes,
i dropped X1 index and recreated it
>--Original Message--
>Have you rebuilt or defragged the x1 index?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
usual
>
>.
>
|||This is what I usually do. Compare the actual plan and estimated plan
(without the hint). Look for areas where the number of rows differ greatly.
Try to understand why the estimate is way-off here. You might need to
update the statistics with the FULLSCAN option in order for SQL Server to
make better estimates.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
sql
This Query :
SELECT 0
FROM
WOTransit -- with (index=x1,readuncommitted)
INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
WHERE WO.Cmd_No=814352
AND ISNULL(WOTransit.Charge_ref,0) <> 0
Since this morning this query is much more slow than usual
If i add : "with (index=x1,readuncommitted) ", the speed
is back to normal. because analyser usually use that
index.
If not, analyser is using a clustered index that is not
related to the query.
why doesn't he use the right index ?
What can i do to fix that ? i allready ran UPDATEUSAGE
and no change.
Thank you !
Donald
Have you rebuilt or defragged the x1 index?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
|||Yes,
i dropped X1 index and recreated it
>--Original Message--
>Have you rebuilt or defragged the x1 index?
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
usual
>
>.
>
|||This is what I usually do. Compare the actual plan and estimated plan
(without the hint). Look for areas where the number of rows differ greatly.
Try to understand why the estimate is way-off here. You might need to
update the statistics with the FULLSCAN option in order for SQL Server to
make better estimates.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:1c5c901c4522c$62730400$a001280a@.phx.gbl...
> Hi,
> This Query :
> SELECT 0
> FROM
> WOTransit -- with (index=x1,readuncommitted)
> INNER JOIN WO On WoTransit.Wo_ref=Wo.Wo_ref
> WHERE WO.Cmd_No=814352
> AND ISNULL(WOTransit.Charge_ref,0) <> 0
>
> Since this morning this query is much more slow than usual
> If i add : "with (index=x1,readuncommitted) ", the speed
> is back to normal. because analyser usually use that
> index.
> If not, analyser is using a clustered index that is not
> related to the query.
> why doesn't he use the right index ?
> What can i do to fix that ? i allready ran UPDATEUSAGE
> and no change.
> Thank you !
> Donald
sql
Monday, March 19, 2012
An Full-Text Catalog Item Count of 0?
Hi,
I've enabled a full-text index on a table having 77 thousand records on a
varchar(50) column. And yet when I when I populate the catalog:
exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
I get an item count,
SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
of 0.
This column has data 95% of the time. What am I missing?
Thank you.
--
Mark Holahan
Check the event log and the gatherer logs for messages:
It is likely you are running into one of the errors in these kb articles
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've enabled a full-text index on a table having 77 thousand records on a
> varchar(50) column. And yet when I when I populate the catalog:
> exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
> I get an item count,
> SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
> of 0.
> This column has data 95% of the time. What am I missing?
> Thank you.
> --
> --
> Mark Holahan
>
|||Bull's eye! Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ek2TowbHFHA.3880@.TK2MSFTNGP10.phx.gbl...
> Check the event log and the gatherer logs for messages:
> It is likely you are running into one of the errors in these kb articles
> http://support.microsoft.com/default...b;en-us;295034
> http://support.microsoft.com/default...b;en-us;317746
> http://support.microsoft.com/default...b;en-us;295772
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
>
|||Hi Hilary,
I have had a similar problem with the Full-text Catalog Item Count of 0,
after I enable some Full-text Indexing from 4 tables. I can view the
table names on the Full-text Catalog, but when double-clicked the
Catalog, the propereties page showed an Item Count of 0.
Because we are developing a back-end database for a SharePoint Services
server, based on the information from the SharePoint Administration
guide, we needed to use Domain Account, instead of the local System
account, after we saw the Item Count of 0 for our first try.
The big question is after we set up the domain account, the Item Count
was still zero.
Is something wrong with the Full-text Search configuration, or on the
SharePoint Service server?
Thanks,
Jeffrey
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Is MSSearch running under the local system account? It must be for this to
work.
Are there any error or warning messages in the application log from MSSearch
or MSSCi?
You might want to consult these kb article for more information on resolving
the typical problems you get this MSSearch and SQL Server.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
"Jeffrey Wang" <cjeffwang@.gmail.com> wrote in message
news:ug43i2TIFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi Hilary,
> I have had a similar problem with the Full-text Catalog Item Count of 0,
> after I enable some Full-text Indexing from 4 tables. I can view the
> table names on the Full-text Catalog, but when double-clicked the
> Catalog, the propereties page showed an Item Count of 0.
> Because we are developing a back-end database for a SharePoint Services
> server, based on the information from the SharePoint Administration
> guide, we needed to use Domain Account, instead of the local System
> account, after we saw the Item Count of 0 for our first try.
> The big question is after we set up the domain account, the Item Count
> was still zero.
> Is something wrong with the Full-text Search configuration, or on the
> SharePoint Service server?
> Thanks,
> Jeffrey
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
I've enabled a full-text index on a table having 77 thousand records on a
varchar(50) column. And yet when I when I populate the catalog:
exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
I get an item count,
SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
of 0.
This column has data 95% of the time. What am I missing?
Thank you.
--
Mark Holahan
Check the event log and the gatherer logs for messages:
It is likely you are running into one of the errors in these kb articles
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've enabled a full-text index on a table having 77 thousand records on a
> varchar(50) column. And yet when I when I populate the catalog:
> exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
> I get an item count,
> SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
> of 0.
> This column has data 95% of the time. What am I missing?
> Thank you.
> --
> --
> Mark Holahan
>
|||Bull's eye! Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ek2TowbHFHA.3880@.TK2MSFTNGP10.phx.gbl...
> Check the event log and the gatherer logs for messages:
> It is likely you are running into one of the errors in these kb articles
> http://support.microsoft.com/default...b;en-us;295034
> http://support.microsoft.com/default...b;en-us;317746
> http://support.microsoft.com/default...b;en-us;295772
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
>
|||Hi Hilary,
I have had a similar problem with the Full-text Catalog Item Count of 0,
after I enable some Full-text Indexing from 4 tables. I can view the
table names on the Full-text Catalog, but when double-clicked the
Catalog, the propereties page showed an Item Count of 0.
Because we are developing a back-end database for a SharePoint Services
server, based on the information from the SharePoint Administration
guide, we needed to use Domain Account, instead of the local System
account, after we saw the Item Count of 0 for our first try.
The big question is after we set up the domain account, the Item Count
was still zero.
Is something wrong with the Full-text Search configuration, or on the
SharePoint Service server?
Thanks,
Jeffrey
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Is MSSearch running under the local system account? It must be for this to
work.
Are there any error or warning messages in the application log from MSSearch
or MSSCi?
You might want to consult these kb article for more information on resolving
the typical problems you get this MSSearch and SQL Server.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
"Jeffrey Wang" <cjeffwang@.gmail.com> wrote in message
news:ug43i2TIFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi Hilary,
> I have had a similar problem with the Full-text Catalog Item Count of 0,
> after I enable some Full-text Indexing from 4 tables. I can view the
> table names on the Full-text Catalog, but when double-clicked the
> Catalog, the propereties page showed an Item Count of 0.
> Because we are developing a back-end database for a SharePoint Services
> server, based on the information from the SharePoint Administration
> guide, we needed to use Domain Account, instead of the local System
> account, after we saw the Item Count of 0 for our first try.
> The big question is after we set up the domain account, the Item Count
> was still zero.
> Is something wrong with the Full-text Search configuration, or on the
> SharePoint Service server?
> Thanks,
> Jeffrey
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)