How To See Who Created A Table In Sql Server at johnsgriffino blog

How To See Who Created A Table In Sql Server. how to see who made a change to a table in sql server. There is information in the metadata catalog about who is the owner of a given object, or to what schema does.

Sql Create View From Multiple Tables QuyaSoft
from quyasoft.com

i was hoping to develop a tool which we can go back to user x and say, you created table abc which is taking up y amount of space. select trace.textdata ,trace.databasename ,trace.objectname ,te.name as eventname ,tsv.subclass_name ,trace.eventclass ,trace.eventsubclass ,trace.starttime ,trace.endtime. You can get some of this information from the default trace, though, since it tracks.

Sql Create View From Multiple Tables QuyaSoft

How To See Who Created A Table In Sql Server If not, can you either truncate the. A primary key is always unique. The database engine enforces the restriction that any primary key value can't be repeated in. how to see who made a change to a table in sql server.