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
>

FTS Installation Problem - unavailable in SQL Server

Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
Search. I can see the Microsoft Search service and it shows as started. But
the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
also report that FTS is not available. SQL Server has been stopped/restarted
but still no luck. Is there something else that needs to happen to make SQL
Server 2K see that FTS is installed?
- Thanks,
Chris M.
Does this help?
http://www.indexserverfaq.com/tablenotenabled.htm
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
"Chris M" <ChrisM@.discussions.microsoft.com> wrote in message
news:C445089B-5F09-40D9-B376-C6F60B669E86@.microsoft.com...
> Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
> Search. I can see the Microsoft Search service and it shows as started.
> But
> the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
> also report that FTS is not available. SQL Server has been
> stopped/restarted
> but still no luck. Is there something else that needs to happen to make
> SQL
> Server 2K see that FTS is installed?
> - Thanks,
> Chris M.