SQL Server Performance Forum – Threads Archive
Find out who created a tableIf 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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? —
Microsoft SQL Server MVP
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.