FT Catalog "optimise" or "populate" differences

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



Hi,

In SQL 2005 does anyone know what the difference between a full text catalogue "optimize" and a "populate" is? In 2000 I think there was only populate.

It seems you can't schedule a normal "populate" in 2005 - only an "optimise".

Nick...
.



Relevant Pages

  • Re: Scripting conditional list box
    ... the drop down boxwon't populate. ... Dim SQL as string ... SQL = "SELECT ApptTime FROM AppointmentTimes WHERE ApptTime not in ... except that you called the query "Time". ...
    (microsoft.public.access.formscoding)
  • Re: Re: Inserting large amounts of data
    ... > I'm using DTS to populate a staging table with raw streams of data (a ... I thought about imbedding the SQL ... Doing the substringing in T-SQL is not the ...
    (comp.databases.ms-sqlserver)
  • Re: Populating date into SQL
    ... datetime field in SQL ... Dim trans As SqlClient.SqlTransaction 'Transaction object ... 'Populate sql ... insertCMD = String.Formatvalues ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Please display the table faster in the datagrid
    ... > Thanks Dmitriy, I did find some 3rd party tools but I'm not ready to ... > recommend purchasing them yet. ... > VFP table would I be able to use mySQLCommand.ExecuteNonQuery() with a SQL ... You can't populate a grid with 60 million records (which ...
    (microsoft.public.vb.database)
  • IIS 6 Security/Authentication Problem?
    ... One of the .asp pages in this sub-web is set to Integrated Windows ... Authentication so that I can pull the users username using ... This page also makes a databse call to SQL2K to populate some drop down ... which to logon to SQL. ...
    (microsoft.public.inetserver.iis)