*.ldf files are becoming smaller each night

While monitoring the logical log files I noticed that they were often smalle
r
in the morning. I've been trying to find what is doing the shrink.
I see nothing in the maintenance plan about trunking the log file and I have
found nothing else.
The only clue I have is that, on a slow day, the date stamp on the file is
just a couple minutes after the machine reboot.
I want to avoid the fragmentation that happens when the file grows.
Can anyone help me explain this?Autoshrink?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:DF4BED2D-93CD-4293-A2C8-819718C3A1EB@.microsoft.com...
> While monitoring the logical log files I noticed that they were often smal
ler
> in the morning. I've been trying to find what is doing the shrink.
> I see nothing in the maintenance plan about trunking the log file and I ha
ve
> found nothing else.
> The only clue I have is that, on a slow day, the date stamp on the file is
> just a couple minutes after the machine reboot.
> I want to avoid the fragmentation that happens when the file grows.
> Can anyone help me explain this?

**changing the logical name**

Hi
In SQL 2000, How can I change the logical name of a database?
Any help would be greatly appreciated.You can use sp_renamedb to change the name of the database. Another option
is to use ALTER DATABASE with MODIFY option. Check SQL Server Books Online
for exact syntax.
Anith