Creating procedure to exec when new DB is created

[Ruslan Kogan]

Hi,

I'm using SQL Server 7 and I was wondering if it is possible to write some
script that automatically creates a folder to store the data file and the
log file when a new db is created.

eg.
if the database is called "dbClients" then the following should be created
and the appropriate files put there.
g:\data\dbclients
g:\log\dbclients

and also, if possible, these folders get removed when the database is
deleted.

Your help is greatly appreciated.