In SQL Server 2005 you can create DDL triggers that can capture such events and log them to a table for reporting, and possibly prevent it.

I'd suggest that you start by reading up about DDL triggers in Books Online.