Very Computer

Sql Server version 7 Newbie

I have a log file of 16megabytes and wish restrict growth to say 17
megabytes.
Similairly I have a data file of 71 megabytes and wish to restrict growth to
72 megabytes.
It is going to be used on a website for read only functionality.  No
updates, deletes or additions at all.

Will there be any consequences of  limiting the size of the log file such as
error messages or whatever, or can I do this safely?

Thanks

Jonathan

Jonathan, if your database is going to be read-only, then, you shouldn't be
having any problems, by restricting the file sizes. You could in fact, set
your database into read-only mode, using sp_dboption command, which results
in faster query response times, as there won't be any locking in this mode.
--
HTH,
Vyas,
SQL Server FAQ, articles, code samples,

http://vyaskn.tripod.com/

Sql Server version 7 Newbie

I have a log file of 16megabytes and wish restrict growth to say 17
megabytes.
Similairly I have a data file of 71 megabytes and wish to restrict growth to
72 megabytes.
It is going to be used on a website for read only functionality.  No
updates, deletes or additions at all.

Will there be any consequences of  limiting the size of the log file such as
error messages or whatever, or can I do this safely?

Thanks

Jonathan