CODEWITHSUNDEEP
sqlt-sql
Chris Rodriguez
Chris Rodriguez

Reputation: 928

Get Table CreateBy attribute from sys.tables

Is there a way to determine who created a user_table in the system tables? I see the create_date, modify_date, but do not see any pointers to who created or modified the tables.

Thanks

Upvotes: 1

Views: 26

Answers (1)

Martin Smith
Martin Smith

Reputation: 453940

This information isn't collected by default.

If the modification you are interested in is fairly recent you can get it from the default trace.

Failing that you might be able to determine it from the transaction logs.

If you need this information ongoing you could create a DDL trigger to log schema changes.

Upvotes: 1

Related Questions