|
Home > Archive > MS SQL Server > March 2006 > Installing full text index on SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Installing full text index on SQL Server
|
|
| thoades@hotmail.com 2006-03-09, 11:23 am |
| 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.
| |
| Paul Zanbaka 2006-03-09, 1:23 pm |
| 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.
>
>
| |
| thoades@hotmail.com 2006-03-10, 7:23 am |
| 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:[color=darkred
]
> sp_fulltext_database
'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
>
> "thoades@hotmail.com" wrote:
>
| |
|
|
|
|
|