Wednesday, March 28, 2012

Installing full text index on SQL Server

A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:

> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
>|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:

> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>sql

No comments:

Post a Comment