Full Text Setup

I'm trying to set up Full-text indexing. I installed the module, the
service shows up in control panel\services, but the option in EM is still
grayed out. Any suggestions?
FYI: SQL2000 on XP pro, rebooted machine...
thanks. -Rob T.http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Rob T" <RTorcellini@.DONTwalchemSPAM.com> wrote in message
news:%23vgfkinWGHA.4960@.TK2MSFTNGP05.phx.gbl...
> I'm trying to set up Full-text indexing. I installed the module, the
> service shows up in control panel\services, but the option in EM is still
> grayed out. Any suggestions?
> FYI: SQL2000 on XP pro, rebooted machine...
> thanks. -Rob T.
>|||I've also found that if this is a remote server then the options can be
disabled, I think this is because EM can't determine if FTS is installed. I
guess its a remote permissions thing. If you log on locally you should find
it enabled
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23I7E5LqWGHA.3972@.TK2MSFTNGP02.phx.gbl...
> http://www.indexserverfaq.com/tablenotenabled.htm
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Rob T" <RTorcellini@.DONTwalchemSPAM.com> wrote in message
> news:%23vgfkinWGHA.4960@.TK2MSFTNGP05.phx.gbl...
>|||Not always, it seems to be a bug somewhere along the line. You can always
use the wizard from the command line to access remote SQL Servers when you
run into this problem. C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqlftwiz.exe /sRemoteServerName /n for trusted, or
/sRemoteServerName /usa /ppassword
You still need to be in the symin role on the server you are trying to
manage.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Simon Sabin" <ContactThroughMyBlog@.nospam.com> wrote in message
news:4438c2ac$1$33888$ed2619ec@.ptn-nntp-reader03.plus.net...
> I've also found that if this is a remote server then the options can be
> disabled, I think this is because EM can't determine if FTS is installed.
> I guess its a remote permissions thing. If you log on locally you should
> find it enabled
> --
> Simon Sabin
> SQL Server MVP
> http://sqljunkies.com/weblog/simons
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23I7E5LqWGHA.3972@.TK2MSFTNGP02.phx.gbl...
>|||How do I know if I am in the symin role ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OCe2ek8WGHA.3848@.TK2MSFTNGP05.phx.gbl...
> Not always, it seems to be a bug somewhere along the line. You can always
> use the wizard from the command line to access remote SQL Servers when you
> run into this problem. C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlftwiz.exe /sRemoteServerName /n for trusted, or
> /sRemoteServerName /usa /ppassword
> You still need to be in the symin role on the server you are trying to
> manage.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Simon Sabin" <ContactThroughMyBlog@.nospam.com> wrote in message
> news:4438c2ac$1$33888$ed2619ec@.ptn-nntp-reader03.plus.net...
installed.
intelligence.
RelevantNoise's
>|||SELECT IS_SRVROLEMEMBER('symin')
*mike hodgson*
http://sqlnerd.blogspot.com
Alan wrote:

>How do I know if I am in the symin role ?
>"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
>news:OCe2ek8WGHA.3848@.TK2MSFTNGP05.phx.gbl...
>
>installed.
>
>intelligence.
>
>RelevantNoise's
>
>
>|||I tried and result is 1.|||It's documented in Books Online:
http://msdn.microsoft.com/library/e..._ia-iz_4f5e.asp
1 means the login is a member of the role.
0 means the login is not a member of the role.
*mike hodgson*
http://sqlnerd.blogspot.com
Alan wrote:

> I tried and result is 1.|||Hi Mike,
So that means my login has admin permission, right?
Do you have any idea why I cannot do a full-text search ?
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OuKuWsUeGHA.1208@.
TK2MSFTNGP02.phx.gbl...
It's documented in Books Online:
http://msdn.microsoft.com/library/e..._ia-iz_4f5e.asp
1 means the login is a member of the role.
0 means the login is not a member of the role.
mike hodgson
http://sqlnerd.blogspot.com
Alan wrote:
I tried and result is 1.|||Alan wrote:

> So that means my login has admin permission, right?
Within the context of that SQL instance, yes.

> Do you have any idea why I cannot do a full-text search ?
No, sorry - I haven't been following the thread so I don't know what
problem you're experiencing exactly (I just saw your question about how
to determine if a login is a symin or not). But I'm not much of a
FTS expert anyway (I generally try to avoid FTS, initially (back in the
old days) because I found it to be a bit of a kludge, ie. being an
external service rather than core to the DB engine). Hilary & Simon
would be much better qualified to talk about FTS than I.

> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OuKuWsUeGHA.1208@.TK2MSFTNGP02.phx.gbl...
> It's documented in Books Online:
> http://msdn.microsoft.com/library/e..._ia-iz_4f5e.asp
> 1 means the login is a member of the role.
> 0 means the login is not a member of the role.
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Alan wrote:
>
>
--
*mike hodgson*
http://sqlnerd.blogspot.comsql

Full text searching in advanced services edition

I have installed the advanced services edition but cannot find out how to build and populate full text catalogs. Nothing shows on the MSSMSE tool and when I try to use a sql command to create a new catalog it says that the full text service is not installed. Am I missing something?

The Full-text Search menus in Management Studio have a dependency on SQL Agent, so they were excluded from Management Studio Express as SQL Express doesn't have SQL Agent.

As far as the error, it is completely possible that FTS is not installed as it is not part of the default installation of Express Advanced. If you did not choose to install FTS from the feature tree, it's not there. You'll need to launch the Express Advanced setup in maintenance mode and verify that you've installed all the components.

If you have installed all the components, then you should check the error log and relay the exact error so we can troubleshoot further.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

full text search on views in express edition

Hi
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
ontario, canada
I am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada
|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:

> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
>
>

full text search on views in express edition

Hi
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
--
ontario, canadaI am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:
> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> >
> > Hi
> >
> > Is full text indexing possible on views in SQL server express edition with
> > advanced services? If Yes then how to do it on a view where I want to do
> > full text search on five different columns?
> >
> > Thanks
> > --
> > ontario, canada
>
>

Full Text Indexing Error

I see a lot of these in my Event log on the SQL Server for my Windows
Sharepoint Services site.
It would be nice to know what files are not being indexed and why.
Posting in the WSS group got me advice to update to SQL Server SP3 (done at
install) and/or post here.
Event Log Messages:
One or more documents stored in image columns with extension 'xls' did not
get full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
One or more documents stored in image columns with extension '' did not get
full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
This normally means your iFilter or related components has/have crashed. Try
to bounce MSSearch to solve this problem.You may need to reboot your server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"David McKenzie" <DavidMcKenzie@.noemail.nospam> wrote in message
news:uL7DVujAFHA.2792@.TK2MSFTNGP15.phx.gbl...
> I see a lot of these in my Event log on the SQL Server for my Windows
> Sharepoint Services site.
> It would be nice to know what files are not being indexed and why.
> Posting in the WSS group got me advice to update to SQL Server SP3 (done
at
> install) and/or post here.
> Event Log Messages:
> One or more documents stored in image columns with extension 'xls' did not
> get full-text indexed because loading the filter failed with error '0x1'.
> Note: These documents will not be passed to MSSearch for indexing, and
> therefore this failure will not be reflected in the end of crawl summary
> statistics.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> One or more documents stored in image columns with extension '' did not
get
> full-text indexed because loading the filter failed with error '0x1'.
> Note: These documents will not be passed to MSSearch for indexing, and
> therefore this failure will not be reflected in the end of crawl summary
> statistics.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
|||OK
A little more information...
The server is rebooted weekly
These errors have been cropping up for a while - So far i have had no
reports from users of any problems, but they are not using Sharepoint's
search very extensivly yet.
I hope to change that, but want to have some confidence in the results.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OnhOjEkAFHA.4028@.TK2MSFTNGP15.phx.gbl...
> This normally means your iFilter or related components has/have crashed.
Try
> to bounce MSSearch to solve this problem.You may need to reboot your
server.[vbcol=seagreen]
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "David McKenzie" <DavidMcKenzie@.noemail.nospam> wrote in message
> news:uL7DVujAFHA.2792@.TK2MSFTNGP15.phx.gbl...
> at
not[vbcol=seagreen]
'0x1'.
> get
>
|||David,
The first event log error indicates that an Excel (*.xls) file did not get
FT Indexed and the 2nd event log error indicates that a file extension of
'' (or NULL) did not get FT Indexed. The former, may occur because of a bad
file, but the latter should not occur, unless you are storing un-known
extensions. You should examine the gather log files (*.gthr) under
\FTDATA\SQLServer\GatherLogs\ with the gthrlog.vbs utility for additional
information and post the output of the gthrlog.vbs utility.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"David McKenzie" <DavidMcKenzie@.noemail.nospam> wrote in message
news:uL7DVujAFHA.2792@.TK2MSFTNGP15.phx.gbl...
> I see a lot of these in my Event log on the SQL Server for my Windows
> Sharepoint Services site.
> It would be nice to know what files are not being indexed and why.
> Posting in the WSS group got me advice to update to SQL Server SP3 (done
at
> install) and/or post here.
> Event Log Messages:
> One or more documents stored in image columns with extension 'xls' did not
> get full-text indexed because loading the filter failed with error '0x1'.
> Note: These documents will not be passed to MSSearch for indexing, and
> therefore this failure will not be reflected in the end of crawl summary
> statistics.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> One or more documents stored in image columns with extension '' did not
get
> full-text indexed because loading the filter failed with error '0x1'.
> Note: These documents will not be passed to MSSearch for indexing, and
> therefore this failure will not be reflected in the end of crawl summary
> statistics.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
|||John,
Thanks for the quick reply.
I had to switch to my network, security and training hats respectivly but am
now under the Sharepoint hat and have the following result:
1/31/2005 12:55:34 AM Add The gatherer has started
1/31/2005 12:55:36 AM Add The initialization has completed
1/31/2005 8:57:26 AM
MSSQL75://SQLServer/1de57479/CB325AA2334BED409E0F527D35A87A67 Add Error
fetching URL, (80041201 - The object was not found. )
1/31/2005 10:20:06 AM
MSSQL75://SQLServer/1de57479/EBB20D5D67E2EC4F820041532CB288BC Add Error
fetching URL, (80041201 - The object was not found. )
1/31/2005 11:03:36 AM
MSSQL75://SQLServer/76cba758/A86817082BA3E0469D8D07C2D70A8905 Add Error
fetching URL, (80041201 - The object was not found. )
1/31/2005 11:03:36 AM
MSSQL75://SQLServer/1de57479/C774194838E91540868BDAF8027CCEC8 Add Error
fetching URL, (80041201 - The object was not found. )
Clear enough, some reference is either expired or corrupt.
In your experience, is this something to be concerned about?
Searches have become much slower than the last time I tried anything, but we
also have 4 or 5 gb more data.
Bt slow, I mean durations of minutes while the SQL Server (dual pentium 4
2.something with 4gb ram) shows 80-95% processor consumed by MSSEARCH.
My users are not making much use of Search in Sharepoint, and at this point
I am holding off on encouraging them
David
btw - Nice pic on your blog - I really need to get out skiing again one of
these years...
"John Kane" <jt-kane@.comcast.net> wrote in message
news:uTVnh0pAFHA.1404@.TK2MSFTNGP11.phx.gbl...
> David,
> The first event log error indicates that an Excel (*.xls) file did not get
> FT Indexed and the 2nd event log error indicates that a file extension of
> '' (or NULL) did not get FT Indexed. The former, may occur because of a
bad[vbcol=seagreen]
> file, but the latter should not occur, unless you are storing un-known
> extensions. You should examine the gather log files (*.gthr) under
> \FTDATA\SQLServer\GatherLogs\ with the gthrlog.vbs utility for additional
> information and post the output of the gthrlog.vbs utility.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "David McKenzie" <DavidMcKenzie@.noemail.nospam> wrote in message
> news:uL7DVujAFHA.2792@.TK2MSFTNGP15.phx.gbl...
> at
not[vbcol=seagreen]
'0x1'.
> get
>

Full Text index catalog population error

Does anyone know what the services are involved during the SQL full
text index catalog population?
Some of my application event log errors are "Error: 80070426 - The
service has not been started.".
I know that my SQL server is running and MSsearch is running. I don't
know any other services needed for this operation.
Thank you in advance for any help!
Its MSSearch, SQL Server, SQL Server Agent (if you are scheduling your
populations).
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
"discover" <hongc@.lanproinc.com> wrote in message
news:1163533752.261545.225040@.f16g2000cwb.googlegr oups.com...
> Does anyone know what the services are involved during the SQL full
> text index catalog population?
> Some of my application event log errors are "Error: 80070426 - The
> service has not been started.".
> I know that my SQL server is running and MSsearch is running. I don't
> know any other services needed for this operation.
> Thank you in advance for any help!
>

Full Install for SP2

I have one production SQL server 2000 with Reporting services SP2 installed
on it. I have a redundent IIS 6.0 just purchased. I went to install RS on
it and point it to the production machine but it won't install because the CD
I have is RS SP1 which isn't compatible with SP2. How can I get my hands on
a Full install of RS SP2 so that I can install it on my new IIS machine?
Thanks,
JohnThere is not a full install with SP2. You have to install and then upgrade
with SP2. SP2 includes all the fixes from SP1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>I have one production SQL server 2000 with Reporting services SP2 installed
> on it. I have a redundent IIS 6.0 just purchased. I went to install RS
> on
> it and point it to the production machine but it won't install because the
> CD
> I have is RS SP1 which isn't compatible with SP2. How can I get my hands
> on
> a Full install of RS SP2 so that I can install it on my new IIS machine?
> Thanks,
> John
>|||Bruce,
Thanks for your reply. I already have SP2 installed. I am trying to
install Reporting Services on a new IIS machine and it won't let me because I
have a RS SP1 install and that is not compatible with SP2. Are you telling
me the only way to install this on my new machine is to completely uninstall
RS, on my production machine, and then reinstall RS on the new IIS machine?
Do you know if MS is going to come out with a CD soon for a full RS SP2
install? Since SP2 is incompatible with SP1 I can't imagine I'll be the only
one with this problem...
Thanks,
John
"Bruce L-C [MVP]" wrote:
> There is not a full install with SP2. You have to install and then upgrade
> with SP2. SP2 includes all the fixes from SP1.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
> >I have one production SQL server 2000 with Reporting services SP2 installed
> > on it. I have a redundent IIS 6.0 just purchased. I went to install RS
> > on
> > it and point it to the production machine but it won't install because the
> > CD
> > I have is RS SP1 which isn't compatible with SP2. How can I get my hands
> > on
> > a Full install of RS SP2 so that I can install it on my new IIS machine?
> > Thanks,
> > John
> >
>
>|||I'm confused on what you are trying to do. Are you setting up up a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
> Bruce,
> Thanks for your reply. I already have SP2 installed. I am trying to
> install Reporting Services on a new IIS machine and it won't let me
> because I
> have a RS SP1 install and that is not compatible with SP2. Are you
> telling
> me the only way to install this on my new machine is to completely
> uninstall
> RS, on my production machine, and then reinstall RS on the new IIS
> machine?
> Do you know if MS is going to come out with a CD soon for a full RS SP2
> install? Since SP2 is incompatible with SP1 I can't imagine I'll be the
> only
> one with this problem...
> Thanks,
> John
> "Bruce L-C [MVP]" wrote:
>> There is not a full install with SP2. You have to install and then
>> upgrade
>> with SP2. SP2 includes all the fixes from SP1.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
>> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>> >I have one production SQL server 2000 with Reporting services SP2
>> >installed
>> > on it. I have a redundent IIS 6.0 just purchased. I went to install
>> > RS
>> > on
>> > it and point it to the production machine but it won't install because
>> > the
>> > CD
>> > I have is RS SP1 which isn't compatible with SP2. How can I get my
>> > hands
>> > on
>> > a Full install of RS SP2 so that I can install it on my new IIS
>> > machine?
>> > Thanks,
>> > John
>> >
>>|||I am setting up redundancy. I have a production IIS and SQL server running
RS SP2. I have a redundant SQL server that is getting updates from the
production server using Double-take. I would like to have the production IIS
machine replicate to the backup IIS machine using the same software. In
order to do this I need all the same products and versions on the redundant
server before I set up the replication. Unfortunately I upgraded my
production IIS and SQL to SP2 before I did the original install of RS on my
backup IIS machine. I tried installing RS but it tells me my CD RS version,
SP1, is incompatible with the production SQL version, SP2. I figured it
would be easy enough to just get a CD with a full install, including SP2,
from MS.
"Bruce L-C [MVP]" wrote:
> I'm confused on what you are trying to do. Are you setting up up a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
> > Bruce,
> > Thanks for your reply. I already have SP2 installed. I am trying to
> > install Reporting Services on a new IIS machine and it won't let me
> > because I
> > have a RS SP1 install and that is not compatible with SP2. Are you
> > telling
> > me the only way to install this on my new machine is to completely
> > uninstall
> > RS, on my production machine, and then reinstall RS on the new IIS
> > machine?
> > Do you know if MS is going to come out with a CD soon for a full RS SP2
> > install? Since SP2 is incompatible with SP1 I can't imagine I'll be the
> > only
> > one with this problem...
> >
> > Thanks,
> > John
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is not a full install with SP2. You have to install and then
> >> upgrade
> >> with SP2. SP2 includes all the fixes from SP1.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
> >> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
> >> >I have one production SQL server 2000 with Reporting services SP2
> >> >installed
> >> > on it. I have a redundent IIS 6.0 just purchased. I went to install
> >> > RS
> >> > on
> >> > it and point it to the production machine but it won't install because
> >> > the
> >> > CD
> >> > I have is RS SP1 which isn't compatible with SP2. How can I get my
> >> > hands
> >> > on
> >> > a Full install of RS SP2 so that I can install it on my new IIS
> >> > machine?
> >> > Thanks,
> >> > John
> >> >
> >>
> >>
> >>
>
>|||You might not be the only one but what you are doing is not the normal way
for redundancy (by normal I mean the way the product is designed to provide
redundancy). RS was designed to provide reduncancy by creating a web farm.
All the IIS boxes use the same, single database server (which could have a
redundancy setup). The downside of this is licensing, each box needs to have
an enterprise license. Although this might still be the case with what you
are doing as well. At a minimum today you need 2 licenses. One for your IIS
box and one for your SQL Server box.
I suggesting reading up on how to install and setup a web farm, could be it
would give you ideas on how to move ahead with this.
Off the top of my head one thing you could do is to temporarily have SQL
Server locally on the second box and install RS. Then when done point it
away from being local to the other SQL Server box and remove SQL Server from
the second IIS box. I know this is possible but have not done it myself.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
news:CC7BDAC3-1F73-4848-A0E8-F190068C363B@.microsoft.com...
>I am setting up redundancy. I have a production IIS and SQL server running
> RS SP2. I have a redundant SQL server that is getting updates from the
> production server using Double-take. I would like to have the production
> IIS
> machine replicate to the backup IIS machine using the same software. In
> order to do this I need all the same products and versions on the
> redundant
> server before I set up the replication. Unfortunately I upgraded my
> production IIS and SQL to SP2 before I did the original install of RS on
> my
> backup IIS machine. I tried installing RS but it tells me my CD RS
> version,
> SP1, is incompatible with the production SQL version, SP2. I figured it
> would be easy enough to just get a CD with a full install, including SP2,
> from MS.
> "Bruce L-C [MVP]" wrote:
>> I'm confused on what you are trying to do. Are you setting up up a web
>> farm?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in message
>> news:DB20322D-8C67-43A0-B520-24BF7E80C34B@.microsoft.com...
>> > Bruce,
>> > Thanks for your reply. I already have SP2 installed. I am trying to
>> > install Reporting Services on a new IIS machine and it won't let me
>> > because I
>> > have a RS SP1 install and that is not compatible with SP2. Are you
>> > telling
>> > me the only way to install this on my new machine is to completely
>> > uninstall
>> > RS, on my production machine, and then reinstall RS on the new IIS
>> > machine?
>> > Do you know if MS is going to come out with a CD soon for a full RS SP2
>> > install? Since SP2 is incompatible with SP1 I can't imagine I'll be
>> > the
>> > only
>> > one with this problem...
>> >
>> > Thanks,
>> > John
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> There is not a full install with SP2. You have to install and then
>> >> upgrade
>> >> with SP2. SP2 includes all the fixes from SP1.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "John Supplee" <JohnSupplee@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:D8929F90-02FE-4782-AECF-E3028CC5C72F@.microsoft.com...
>> >> >I have one production SQL server 2000 with Reporting services SP2
>> >> >installed
>> >> > on it. I have a redundent IIS 6.0 just purchased. I went to
>> >> > install
>> >> > RS
>> >> > on
>> >> > it and point it to the production machine but it won't install
>> >> > because
>> >> > the
>> >> > CD
>> >> > I have is RS SP1 which isn't compatible with SP2. How can I get my
>> >> > hands
>> >> > on
>> >> > a Full install of RS SP2 so that I can install it on my new IIS
>> >> > machine?
>> >> > Thanks,
>> >> > John
>> >> >
>> >>
>> >>
>> >>
>>

FTS results page question

I'm an FTS newb so please be gentle.
When using most search services the results returned are accompanied by a
snippet or excerpt of the full text that scored a hit showing the matched
word(s)/phrase in context.
For example, if I search for "full-text search" I might receive this as one
entry in the list of results:
... immediately alerts you if a server gets out ... a graphical
administration interface, an SQL query tool ... It provides the full-text
search based on Microsoft Indexing ...
Can I get a similar snippet or excerpt using FTS or will I have to roll my
own solution? Any suggestions regarding how to implement the latter would
be greatly appreciated.
Thanks,
Will
Hi Will,
Not to worry, as I and others who post the replies here, know a great deal
about SQL Full-text Search (FTS ;-)
Could you post the output of the following SQL script that will provide info
on your SQL Server and OS platform?
use master
go
SELECT @.@.language
SELECT @.@.version
go
If I correctly understand your requirement, you want a range of words, plus
and minus distance from the search word. Correct?
Assuming so, then using a table (pub_info) in the Pubs database that is
already FT-enabled on the TEXT column (pr_info), you could use the following
SQL code to get the results you want:
-- The following SQL FTS query on the pubs table pub_info will return rows
that match the FTS search word (books)
-- and the near by words from 20 characters before to 100 characters after
the searched keyword(books).
SELECT pub_id, SubString(pr_info,PatIndex ('%books%',pr_info)-20,100)
FROM pub_info
WHERE Contains(pr_info, 'books')
/* returns the following results:
pub_id
-- ---
9952 t data for Scootney Books, publisher 9952 in the pubs database.
Scootney Books is located in New Yor
0736 t data for New Moon Books, publisher 0736 in the pubs database. New
Moon Books is located in Boston,
(2 row(s) affected)
*/
You can vary the length of the results via the PatIndex parameters.
Hopefully, this is what you're looking for!
Regards,
John
"William Wise" <will@.digitalelite.com> wrote in message
news:Xns951582AA063F8willdigitalelitecom@.68.1.17.6 ...
> I'm an FTS newb so please be gentle.
> When using most search services the results returned are accompanied by a
> snippet or excerpt of the full text that scored a hit showing the matched
> word(s)/phrase in context.
> For example, if I search for "full-text search" I might receive this as
one
> entry in the list of results:
> ... immediately alerts you if a server gets out ... a graphical
> administration interface, an SQL query tool ... It provides the full-text
> search based on Microsoft Indexing ...
> Can I get a similar snippet or excerpt using FTS or will I have to roll my
> own solution? Any suggestions regarding how to implement the latter would
> be greatly appreciated.
> Thanks,
> Will
|||Hi John,
Here's the info:
us_english
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.2 (Build 3790: )
Thanks for the quick reply. Works like a charm. I'll have to futze with
it some more to get it to prefix the pattern with <STRONG>tags</STRONG>.
Seems like this will require me to parse a complex user-submitted search
string if I want to show instances of each hit.
Will
"John Kane" <jt-kane@.comcast.net> wrote in
news:e6LiFCIXEHA.1684@.tk2msftngp13.phx.gbl:

> Hi Will,
> Not to worry, as I and others who post the replies here, know a great
> deal about SQL Full-text Search (FTS ;-)
> Could you post the output of the following SQL script that will
> provide info on your SQL Server and OS platform?
> use master
> go
> SELECT @.@.language
> SELECT @.@.version
> go
> If I correctly understand your requirement, you want a range of words,
> plus and minus distance from the search word. Correct?
> Assuming so, then using a table (pub_info) in the Pubs database that
> is already FT-enabled on the TEXT column (pr_info), you could use the
> following SQL code to get the results you want:
>
> -- The following SQL FTS query on the pubs table pub_info will return
> rows that match the FTS search word (books)
> -- and the near by words from 20 characters before to 100 characters
> after the searched keyword(books).
> SELECT pub_id, SubString(pr_info,PatIndex ('%books%',pr_info)-20,100)
> FROM pub_info
> WHERE Contains(pr_info, 'books')
> /* returns the following results:
> pub_id
> --
> --
> 9952 t data for Scootney Books, publisher 9952 in the pubs database.
> Scootney Books is located in New Yor
> 0736 t data for New Moon Books, publisher 0736 in the pubs database.
> New Moon Books is located in Boston,
> (2 row(s) affected)
> */
> You can vary the length of the results via the PatIndex parameters.
> Hopefully, this is what you're looking for!
> Regards,
> John