We help IT Professionals succeed at work.

Find user who created table??

326 Views
Last Modified: 2012-05-05
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2012

Commented:
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.
CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks!
CERTIFIED EXPERT
Top Expert 2012

Commented:
>>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.
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
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...
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.