>I have an MSDE database being used by an application, but the tempdb log file keeps getting too large. How can I connect to this to set it to simple logging? The server space is very limited and specific to this application. There is not room to install SQL Server Enterprise.
>
>Your help is greatly appreciated.

Rollin,

Restarting MSDE SQL Server service should resize the transaction log of the tempdb database to its original size.


Cheers,

Zoran