Re: SQL Enable FullText automaticly on reboot

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 14:26:30 -0500

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: ADO.NET 2.0 Asynchronous Command Execution: Independant of Web Session?
    ... i can execute a simple SP ... If this is SQL Server, perhaps you can set up a SQL Agent job and kick it ... off with the sp_start_job stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Continue SP after Database Access Failure
    ... Error handling in SQL Server 2000 is "somewhat" problematic as you have ... I use the following trick of nesting the execution scopes: ... > Over night we take a copy of various live SQL databases onto another SQL ... > I have a stored procedure that compares the latest live data against the 1 ...
    (microsoft.public.sqlserver.programming)
  • 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)
  • How can I find out information about process based on spid?
    ... sometimes I cannot connect to the server using enterprise ... execute sp_who2 from query analyzer... ... This stored procedure provides me with the list of spids ...
    (microsoft.public.sqlserver.server)