asked on

Find user who created table??

Hi,

We are using SQL Server 2005.

I urgently need to find a way to find out who created some tables in one of our databases. Is this possible without purchasing some third party tool?

Thanks,

-ws

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Kevin Cross

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Perkins

Now that the horse has effectively escaped the barn you can close the door by implementing approriate permissions or if you are unable to do that than implement DDL Triggers.

SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Westside2004

ASKER

Thanks!

Anthony Perkins

>>red-gate.com has a product out there that is supposed to be similar to the lumigent log explorer <<
Unfortunately it is only compatible with SQL Server 2000. Apparently they could not negotiate the appropriate license from Microsoft for SQL Server 2005.

chapmandew

Well that sucks. I know there is a design document you can obtain from MS that gives you some sort of direction as to the internals for developing this kind of software. But...you have to be an ISP to get it. Not sure why the red-gate product hasn't upgraded their software for this...