question

harsimranjeetsinghwasson avatar image
harsimranjeetsinghwasson asked

How to check modify by for object modified in sql server

Need to check modify by for modified object, no DDL trigger to be used.
sql-server-2008tsqldba
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
There is no way to track this for certain by default within SQL Server. But, you can set up an extended events session and capture object_altered, object_created, objected_deleted events. That will tell you what, when and who made changes to the system. Here's an article on how to get going with [extended events][1]. [1]: http://www.mssqltips.com/sqlservertip/2155/getting-started-with-extended-events-in-sql-server-2008/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
+1 and I only add, that for recent changes a default trace can be checked. There is also report "Schema Changes History" in SSMS, which shows schema modifications covered by default trace.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.