Hi,

we create after installation of our application, if USE HM fails, with the following t-sql statement a database:

create database HM

We don't want give the File option FILENAME='c:\...', because we don't want to set absolute paths on SQL-Server machine (rights, ...).

We need commands for

- setting maxsize of transaction log from a unlimited size to a limited size

?ALTER DATABASE HM MODIFY FILE (NAME = N'HM_log ', MAXSIZE = 10)

- reducing (or deleting) size of transaction log, because maxsize can't
be reduced to a mb size lower than the actual size.

What is a recommended size for transaction log ?

Thank you,
Andreas