[2005] Who created this table?

Is there a command I can use to find out WHO created a specific table?
~LeShort of asking your coworkers?

If you have Lumigent's Log Explorer, you can extract some of that information (at least when the table was created) from the transaction logs or the transaction log backups.

If you do not have the applicable transaction logs, you are pretty much reduced to trying to figure out who has rights to create tables, and asking them.|||Unless it was a sandbox (so who would care anyway), I would have total control over my databases.

I'm not too sanguin about a wild west show|||Unless it was a sandbox (so who would care anyway), I would have total control over my databases.

I'm not too sanguin about a wild west show

It is a sandbox, but we told our developers not to create dummy tables. So we are trying to crack down.

So it looks like Sql Server 2005 has NO way of determining who created a table. That's too bad.

`Le|||For 2005 you can define DDL triggers that will fire on a create table statement. You can use them to create an audit trail.