Re: FullText catalog of wss - SQL 2000
From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 04/23/04
- Next message: John Kane: "Re: Optional CONTAINS"
- Previous message: mustafa jarrar: "Estimate time to populate full text index"
- In reply to: John Kane: "Re: FullText catalog of wss - SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Apr 2004 19:44:40 +0300
Ummm, John. "Mike" was only saying that someone else would have to provide
Manu / Abhilash with the information *he* wanted on SQL Server 2K
Thanks however as always for coming in with pertinent information and
expertise.
Mike Walsh, Helsinki, Finland (the very same)
"John Kane" <jt-kane@comcast.net> wrote in message
news:#x7JZCVKEHA.2716@tk2msftngp13.phx.gbl...
> Abhilash,
> I saw you post in the private Yukon FTS newsgroup and while I don't have
WSS
> installed on my Yukon server, I somehow suspect that WSS will not work
with
> Yukon Beta1. The Yukon (SQL Server 2005) FTS engine has be completely
> re-design and as a beta1 product this version may not have all the
backward
> compatibility support for WSS.
>
> However, WSS and SQL Server 2000 do work together, but there are
> cross-product issues that often need to be identified and then resolved.
> I've added the SQL Server 2000 Full-text Search (FTS) newsgroup -
> microsoft.public.sqlserver.fulltext - to the distribution list and changed
> the title to SQL Server 2000 for your SQL Server 2000 specific issues.
>
> Could you provide Mike's requested info via the following SQL Server 2000
> system stored procedures?
>
> use <your_database_name>
> go
> SELECT @@language
> SELECT @@version
> EXEC sp_help_fulltext_catalogs
> EXEC sp_help_fulltext_tables
> EXEC sp_help_fulltext_columns
> EXEC sp_help <your_FT-enable_table_name>
> go
>
> Also, review your server's Application event log for any "Microsoft
Search"
> or Mssci source events (warnings or errors) that occurred near the
date/time
> you attempted to enable, activate and run a Full Population on your
> FT-enable table.
>
> NOTE: You MUST do the above on your server where you have WSS and SQL
Server
> 2000 installed and NOT on the server where you have Yukon installed.
>
> Regards,
> John
>
>
>
>
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:uz07HgTKEHA.3184@TK2MSFTNGP10.phx.gbl...
> > > With respect to Sql Server 2K can you please tell me the columns,
> tables
> > on
> > > which catalogs are created..
> >
> > I'm sure someone else better up on this than me will be able to respond.
> (So
> > they don't all wait for me to reply)
> >
> > Mike Walsh, Helsinki, Finland
> >
> >
> > "Manu" <manu_msnews@yahoo.co.in> wrote in message
> > news:ObICm4RKEHA.1892@TK2MSFTNGP09.phx.gbl...
> > > Hi Mike,
> > >
> > > Sorry for the post. I have already posted on Yukon beta newsgroup...
> > >
> > > With respect to Sql Server 2K can you please tell me the columns,
> tables
> > on
> > > which catalogs are created..
> > >
> > > Best regards,
> > > Abhilash
> > >
> > > "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> > > news:#73CUaRKEHA.952@TK2MSFTNGP12.phx.gbl...
> > > > As Yukon is still in restricted beta you should ask any questions
> about
> > it
> > > > at the Yukon beta newsgroups only.
> > > >
> > > > The WSS that we discuss here uses SQL Server 2K.
> > > >
> > > > Mike Walsh, Helsinki, Finland
> > > > WSS FAQ at wss.collutions.com
> > > > Please post questions to the newsgroup only.
> > > >
> > > >
> > > > "Manu" <manu_msnews@yahoo.co.in> wrote in message
> > > > news:%23lLo$ERKEHA.2472@TK2MSFTNGP10.phx.gbl...
> > > > > hi,
> > > > >
> > > > > I am not sure if this the right group to ask the following
question.
> I
> > > > > apologise if it is not
> > > > >
> > > > > I have WSS with Yukon on Windows server 2003. I have enabled full
> > text
> > > > > search in WSS central administration page. When i create a new
site
> > the
> > > > > catalog are created in MSSQL\FTDATA as ix_STS_******. But when i
> > search
> > > > from
> > > > > Sharepoint i get no results.
> > > > >
> > > > > On investigating i see that the there are two tables that are
> fulltext
> > > > > indexed
> > > > > 1) Docs
> > > > > 2) User Data
> > > > >
> > > > > Using sp_help_fulltext_tables i see that Docs table is not
> > > > > FULLTEXT_INDEX_ACTIVE. I try to make it active by saying
> > > > "sp_fulltext_table
> > > > > 'Docs','activate' ". But it says that "Cannot activate full text
> > search
> > > > for
> > > > > table Docs because no columns have enabled for full text search".
> > > > >
> > > > > Can someone please tell me why no columns have been enabled for
full
> > > text
> > > > > enabled in the first place?
> > > > >
> > > > > In addition for the table "User Data" there are 98 columns that
have
> > > been
> > > > > fulltext indexed and the column names are "nvarchar1" ,
"nvarchar2",
> > > > > "navarchar3" etc. Is this normal?
> > > > >
> > > > > Any idea why this is so?
> > > > >
> > > > > Please note that i can independently create some arbitary catalogs
> and
> > > > full
> > > > > text index and search using Contains query
> > > > >
> > > > > If someone could tell me which columns of the above table are
> indexed
> > > then
> > > > i
> > > > > could manually build the catalog and populate them and the use it
> for
> > > > > searching.
> > > > >
> > > > > Thanks in advance
> > > > > Best regards,
> > > > > Abhilash
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: John Kane: "Re: Optional CONTAINS"
- Previous message: mustafa jarrar: "Estimate time to populate full text index"
- In reply to: John Kane: "Re: FullText catalog of wss - SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
