Professional Web Applications Themes

Start Indexing Service - Microsoft SQL / MS SQL Server

Hi Paul, Use the following code. You can adjust the delay as necessary. WHILE DATABASEPROPERTYEX('<database name>', 'Status') <> 'ONLINE' WAITFOR DELAY '0:0:10' -- Wait 10 seconds EXEC sp_fulltext_database 'enable' -- Jacco Schalkwijk MCDBA, MCSD, MCSE Database Administrator Eurostop Ltd. "Paul" <com> wrote in message news:%phx.gbl...  it  immediately ...

  1. #1

    Default Re: Start Indexing Service

    Hi Paul,

    Use the following code. You can adjust the delay as necessary.

    WHILE DATABASEPROPERTYEX('<database name>', 'Status') <> 'ONLINE'
    WAITFOR DELAY '0:0:10' -- Wait 10 seconds
    EXEC sp_fulltext_database 'enable'

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Paul" <com> wrote in message
    news:%phx.gbl... 
    it 
    immediately 


    Jacco Guest

  2. #2

    Default Re: Start Indexing Service

    I have tried the code, but it still doesn't seem to work. Maybe I should be
    checking another database property (instead of Status). The problem is that
    if I use 'IsFulltextEnabled' it returns a 1, i.e. it says it is enabled but
    the folder (location of text index) doesn't exist.

    "Jacco Schalkwijk" <co.uk> wrote in message
    news:%phx.gbl... [/ref]
    a [/ref]
    to 
    > it 
    > immediately [/ref]
    because 
    >
    >[/ref]


    Paul Guest

  3. #3

    Default Re: Start Indexing Service

    When the database is restored and I check the 'IsFulltextEnabled' property,
    it returns 1. However, the actual folder in FTDATA directory is not created
    and so the text indexing doesn't work. I suppose I am really looking for a
    function that knows if it is working or not. I have however thought of
    another way of doing it. I will put a job in the SQL server agent to run 10
    minutes after the database is created. Thanks for your help.

    Paul

    "Jacco Schalkwijk" <co.uk> wrote in message
    news:%phx.gbl... 
    see 
    catalogs, 
    database 
    text 
    > be 
    > that 
    > but [/ref]
    > as [/ref][/ref]
    need [/ref][/ref]
    can 
    > > because [/ref]
    > text [/ref][/ref]
    the 
    > >
    > >[/ref]
    >
    >[/ref]


    Paul Guest

Similar Threads

  1. How to query the indexing service? ASP.NET & IIS
    By Glitch808 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 9th, 02:31 PM
  2. Indexing Service
    By Bankster in forum Windows Server
    Replies: 3
    Last Post: July 29th, 01:13 PM
  3. Replies: 3
    Last Post: October 17th, 05:47 PM
  4. ASP and Indexing Service
    By sebastian in forum ASP
    Replies: 0
    Last Post: August 27th, 02:50 PM
  5. MS Indexing Service
    By CG in forum ASP.NET General
    Replies: 1
    Last Post: August 4th, 04:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139