Find out who created a table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Find out who created a table

If multiple people are using the sa password is there any way to find out who created a table in a certain database. I know you can view when a table was created. But is there anyway to map it back to say user machine ID ?????
As far I know, no.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
No. You should restrict others from using sa user
Madhivanan Failing to plan is Planning to fail
I’m not aware of any method to find this out. And as has been said, you know, you’re having a potential security risk? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Not unless you use any third party tools to audit the database events. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>