full text search sql 2000 and indexed views

Hi,
Is it possible to do a full text catalogue on an indexed view in SQL 2000?
It looks like you can only do tables and the functionality for indexed views
is in SQL 2005, is this correct?
Thanks
You are correct, you can only full-text index indexed views in SQL 2005.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
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
"Letford" <Letford@.discussions.microsoft.com> wrote in message
news:AAA3603B-F2E6-4FCB-838A-7FC07FF1CBEF@.microsoft.com...
> Hi,
> Is it possible to do a full text catalogue on an indexed view in SQL 2000?
> It looks like you can only do tables and the functionality for indexed
> views
> is in SQL 2005, is this correct?
> Thanks

Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
Silmar
Hi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>

Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
SilmarHi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>

Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
SilmarHi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>