Randy Doub (11/14/2007)
In 2005 you can add a DDL Trigger to prevent table alters and drops:
The biggest issue that's being discussed is due to some end user executing a SELECT * on a huge table with no WHERE clause... causing performance issues for obvious reasons. As long as they have a tool which can hook to the database, this is always going to be an issue, whether it's SSMS or Excel. You could use the query governor, but this nukes a legitimate costly query, too.
K. Brian Kelley
@kbriankelley