Is there any way, via systems tables or other method, to capture the NT or SQL User name when the user is listed as sysadmin? For example I'd like to know which user is the owner of an object and dbo, for obvious reasons, does not supply the detail I'm looking for.
I was hoping to find this information stored in the system tables, however all I find is the user names associated with the db and all objects owned by dbo...very frustrating!
I'd like to create a metadata table within each db, that captures each object created and NT or SQL username who created the object along with dates and other important info (documentation is not something we are good at keeping up with). The whole process would be automated, so developers don't have to worry documenting who did what.
Any help is much appreciated!!
I was hoping to find this information stored in the system tables, however all I find is the user names associated with the db and all objects owned by dbo...very frustrating!
I'd like to create a metadata table within each db, that captures each object created and NT or SQL username who created the object along with dates and other important info (documentation is not something we are good at keeping up with). The whole process would be automated, so developers don't have to worry documenting who did what.
Any help is much appreciated!!