Hi,

I need to know or verify that when you Refresh a catalog (from Bizdesk) is i
t the same as using the Full Text Catalog Wizard when you Right-Click the Ca
talog Table?

I use scripts in SQL to bring in all the updates for my catalog that has abo
ut 80000 line. But I notice that the changes does NOT show up immediately. I
f I do the Refresh then I can search the items i.e. those that were added an
d find them. However, since
the whole pint is to automate this I wanted to see if I can add some SQL cod
e or RUN a stored procedure already exisiting or schedule to run the Full te
xt Indexing on the catalog(after the initial WIZARD setup).

Can some one help with suggestions or confirm that these will do the same. A
lso I am not sure of the Refreshing of the Cache that the "REFRESH" in Bizde
sk does.

[ Post a follow-up to this message ]

When you so a refresh Bizdesk does two things
1. Starts an incremental population of the fulltext indexes for all the
catlaogs. This is similar to what you can do through SQL enterprise manager.
2. Some of the CS2002 runtime components  cache information to prevent going
to the database on every request If the information changes cliking on
Refresh will refreshs the information cached by these components

Thanks
Vinayak Tadas
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure!  For more info visit http://www.microsoft.com/security.  Please
reply to the newsgroups only.  Thanks

"Jim B" <anonymous@discussions.microsoft.com> wrote in message
news:A1FE31F8-F143-4517-BC1D-47F102F35144@microsoft.com...
> Hi,
>
> I need to know or verify that when you Refresh a catalog (from Bizdesk) is
it the same as using the Full Text Catalog Wizard when you Right-Click the
Catalog Table?
>
> I use scripts in SQL to bring in all the updates for my catalog that has
about 80000 line. But I notice that the changes does NOT show up
immediately. If I do the Refresh then I can search the items i.e. those that
were added and find them. However, since the whole pint is to automate this
I wanted to see if I can add some SQL code or RUN a stored procedure already
exisiting or schedule to run the Full text Indexing on the catalog(after the
initial WIZARD setup).
>
> Can some one help with suggestions or confirm that these will do the same.
Also I am not sure of the Refreshing of the Cache that the "REFRESH" in
Bizdesk does.

[ Post a follow-up to this message ]