usky1
asked on
who created a sql table
Is there a way to find out who created a sql table? We have tables that were created over the past 5 years all owned by dbo. Can I find any more information on the creation?
.. won't that just return 'dbo' ?
ASKER
agx - that is all it does return. Do you have any suggestions?
Sorry, no. I'm not sure the system tables store even store additional info. Beyond the owner, creation/modification that is. Especially if they were created by a sql login like "sa" or something.
- no, you probably can't. there is a method to get such information from the transaction log but not sure if its still hold the 5 years back log:
http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx
Just confirming that there is no way. "dbo" is always replacing real user's info, even if Windows Authentication is used. Only if there is no mapping to dba, the user is maintained as schema owner - and again, nowhere else.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry about the delay in responding.
The article is what i was looking for. Thanks
The article is what i was looking for. Thanks
Open in new window
src link
http://www.sqlservercentral.com/Forums/Topic324773-149-1.aspx#bm324899