Logging of Schema changes

Is there a way to log any schema changes on databases(Eg change in datatype in a database) and who made the change
Regard
JonasHi,
There is no functinality build in to audit schema changes in SQL Server. But
you could try the free utility by Lumigent. (utility is "Lumigent Schema
Alert")
Download and test it from :
http://www.lumigent.com/downloads/schemaalert/
Thanks
Hari
MCDBA
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ECD9EE38-ACC0-4899-92A1-34CAB7BEFDE8@.microsoft.com...
> Is there a way to log any schema changes on databases(Eg change in
datatype in a database) and who made the change?
> Regards
> Jonas|||also check out www.dbghost.com for database configuration and change management.