Re: SQL Enable FullText automaticly on reboot

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kane (jt-kane_at_comcast.net)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 12:52:44 -0700

Brian,
I'm not sure why you need to run 'sp_fulltext_enable' as it's not a valid
SQL Server 2000 system Full-text Search stored procedure, such as:

sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_getdata
sp_fulltext_service
sp_fulltext_table

What does sp_fulltext_enable do? If it re-enables FTS in databases, then you
have a much bigger problem than just how to mark it as a startup procedure.
FYI, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext.

Regards,
John

"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
news:OeJjJo1mEHA.3452@TK2MSFTNGP15.phx.gbl...
> Create a stored procedure and mark it as a startup stored procedure
>
> exec sp_procoption 'procFoo', 'startup', 'true'
>
> --
> Keith
>
>
> "Brian Henry" <brianiupmsdn@newsgroups.nospam> wrote in message
> news:%235fuJl1mEHA.2740@TK2MSFTNGP12.phx.gbl...
> > Is there a way to execute the sp_fulltext_enable stored proc automaticly
> > after a server rebooted on all the databases in the server? maybe with a
> job
> > or something? its getting a little annoying having to run it again on
> every
> > database after we reboot our development server... thanks
> >
> >
>

Relevant Pages

  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: How to test a custom conflict resolver procedure
    ... once I set my stored procedure as a custom resolver? ... Here is an example of a custom resolver I wrote which might help you ... --creating the stored procedure conflict resolver ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: quality of service
    ... company that hosts my company's web site and connected SQL Server database. ... The same stored procedure is called from a number of different web pages ... The company that hosts my web site and connected SQL ... this clustering is indicative of slowed or failed SQL Server responses due ...
    (microsoft.public.sqlserver.server)
  • Re: Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parame
    ... The @RowV Values when it reaches the stored procedure on SQL server always gets reset to 0x00 No matter what value I set it to. ... I am using timestamps to determine if the row has been updated on the server before I apply the new updates. ... @ProviderID smallint, ... @RowOut timestamp OUTPUT ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)