Determine what user created objects in SQL Server

by

If the object was recently created, you can check the Schema Changes History report, within the SQL Server Management Studio, which “provides a history of all committed DDL statement executions within the Database recorded by the default trace”:

enter image description here

You then can search for the create statements of the objects. Among all the information displayed, there is the login name of whom executed the DDL statement.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. How to update two tables in one statement in SQL Server 2005?
  4. SQL query to select dates between two dates
  5. Create a date from day month and year with T-SQL
  6. Selecting COUNT(*) with DISTINCT
  7. How to return multiple values in one column (T-SQL)?
  8. SQL – Subtracting a depleting value from rows
  9. SQL Server : Transpose rows to columns
  10. Is it possible to select sql server data using column ordinal position
  11. SELECT FOR UPDATE with SQL Server
  12. Easiest way to populate a temp table with dates between and including 2 date parameters
  13. How can a LEFT OUTER JOIN return more records than exist in the left table?
  14. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  15. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  16. Dynamic SQL to generate column names?
  17. Extracting hours from a DateTime (SQL Server 2005)
  18. Column name or number of supplied values does not match table definition
  19. How to split string using delimiter char using T-SQL?
  20. How to find consecutive rows based on the value of a column?
  21. OPENXML with xmlns:dt
  22. SQL server select distinct rows using most recent value only
  23. How to escape square brackets inside square brackets for field name
  24. Average of multiple columns
  25. Eliminate and reduce overlapping date ranges
  26. Cumulative Total in MS Sql server [duplicate]
  27. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  28. Compare dates in T-SQL, ignoring the time part
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. Distributed transaction error?

Leave a Comment