full text incremental population

Hi!
Is there any possibility to populate indexes for inserted rows only
(or not to updated rows)
Regards
MaxOn Apr 4, 10:27 am, maxl...@.gmail.com wrote:
> Hi!
> Is there any possibility to populate indexes for inserted rows only
> (or not to updated rows)
> Regards
> Max
pls... if anyone has came up with same problem. share your knowledge

full text incremental population

Hi!
Is there any possibility to populate indexes for inserted rows only
(or not to updated rows)
Regards
Max
On Apr 4, 10:27 am, maxl...@.gmail.com wrote:
> Hi!
> Is there any possibility to populate indexes for inserted rows only
> (or not to updated rows)
> Regards
> Max
pls... if anyone has came up with same problem. share your knowledge

Full mode to Simple mode in SQL2000?

Hi all,
I have two DBs that set as Full mode which has a t-log and
it seems like contains some data.
These DBs are updated by clients 24/7
If I set it to Simple mode, does data from Log will be
updated to DB and truncate it automatically? And not
affect any transaction from clients?
Also, how can I see if there is any data in Transaction
log? Any Stored procedure in query analyzer?
Thanks in advance.
Lintadsl"Lintadsl" <anonymous@.discussions.microsoft.com> wrote in message
news:000f01c3a551$cd775630$a401280a@.phx.gbl...
> Hi all,
> I have two DBs that set as Full mode which has a t-log and
> it seems like contains some data.
> These DBs are updated by clients 24/7
> If I set it to Simple mode, does data from Log will be
> updated to DB and truncate it automatically?
Yes it will.
>And not affect any transaction from clients?
It will not effect any active transaction.
> Also, how can I see if there is any data in Transaction
> log? Any Stored procedure in query analyzer?
You would need a 3rd party product like lumnigent to view any data in the
transaction log. You can use DBCC OPENTRAN to see if there are any open
transactions.
You also need to be aware that if you switch the database from Full to
Simple recovery you loose the ability to recover any transactions, since the
last full database backup.
Steve|||>--Original Message--
>"Lintadsl" <anonymous@.discussions.microsoft.com> wrote in
message
>news:000f01c3a551$cd775630$a401280a@.phx.gbl...
>> Hi all,
>> I have two DBs that set as Full mode which has a t-log
and
>> it seems like contains some data.
>> These DBs are updated by clients 24/7
>> If I set it to Simple mode, does data from Log will be
>> updated to DB and truncate it automatically?
>Yes it will.
>>And not affect any transaction from clients?
>It will not effect any active transaction.
>> Also, how can I see if there is any data in Transaction
>> log? Any Stored procedure in query analyzer?
>You would need a 3rd party product like lumnigent to view
any data in the
>transaction log. You can use DBCC OPENTRAN to see if
there are any open
>transactions.
>You also need to be aware that if you switch the database
from Full to
>Simple recovery you loose the ability to recover any
transactions, since the
>last full database backup.
>Steve
>
>.
>

FTS index updating

Hello,
Is it possible to know status of FTS index on value in some column of
row, I mean, how can I know FTS index have been updated already or haven't
? For example, value of some row has been changed, but FTS index hasn't
been changed yet. I need to know when after value updating I can run FTS
queries. Does any body know some way to do this, and is it possible or not?
Thank you
There are many ways of doing this - however, they are all complex.
If you are using change tracking you could poll sysfulltextnotify, and key
off the ftkey column which corresponds to your primary key.
You could also enable logging and poll the log looking for the pk value. To
do this go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000500
005 (using the SQL 0000X0000X which corresponds to your catalog), and set
LogDisabled to 1.
Then there is the code sample which accompanies this article which can be
used to trap for a specific row.
http://msdn.microsoft.com/library/de...tml/sp04f9.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<denis_rusakov@.epam.com> wrote in message
news:epbCZ%23mnFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hello,
> Is it possible to know status of FTS index on value in some column of
> row, I mean, how can I know FTS index have been updated already or haven't
> ? For example, value of some row has been changed, but FTS index hasn't
> been changed yet. I need to know when after value updating I can run FTS
> queries. Does any body know some way to do this, and is it possible or
not?
> Thank you
>
>
|||Thank you very much
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23pyvuPonFHA.572@.TK2MSFTNGP15.phx.gbl...
> There are many ways of doing this - however, they are all complex.
> If you are using change tracking you could poll sysfulltextnotify, and key
> off the ftkey column which corresponds to your primary key.
> You could also enable logging and poll the log looking for the pk value.
> To
> do this go to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000500
> 005 (using the SQL 0000X0000X which corresponds to your catalog), and set
> LogDisabled to 1.
> Then there is the code sample which accompanies this article which can be
> used to trap for a specific row.
> http://msdn.microsoft.com/library/de...tml/sp04f9.asp
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> <denis_rusakov@.epam.com> wrote in message
> news:epbCZ%23mnFHA.3036@.TK2MSFTNGP14.phx.gbl...
> not?
>