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?
Regards
Jonas
Hi,
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.